Business Case #3 - Market Basket Analysis

Authors:

Débora Santos (m20200748),Pedro Henrique Medeiros (m20200742), Rebeca Pinheiro (m20201096)

Group D - D4B Consulting

Installing and import packages

Maybe it will be necessary install some 'special' packages to this notebook works.

Please follow the next cells and check if it's necessary

#Install package mlxtend
#!pip install mlxtend

#Install package algorithmx
#!pip install algorithmx

# Import packages
import pandas as pd
import numpy as np
import datetime as dt
from mlxtend.frequent_patterns import apriori
from mlxtend.frequent_patterns import association_rules
import matplotlib.pyplot as plt
import networkx as nx
import seaborn as sns
import plotly.io as pio
pio.renderers
import plotly.graph_objects as go
import dash
import dash_bootstrap_components as dbc
import dash_core_components as dcc
import dash_html_components as html
import dash_table
from dash.dependencies import Input, Output
import plotly.express as px
from algorithmx import jupyter_canvas

Collect initial data

#import dataset
orders = pd.read_csv('orders.csv',sep=",")
orders_prod = pd.read_csv('order_products.csv',sep=",")
departments = pd.read_csv('departments.csv',sep=",")
products = pd.read_csv('products.csv',sep=",")
pd.set_option('display.max_rows', 500)
pd.set_option('display.max_columns', 500)
pd.set_option('display.width', 1000)

Describe, explore and assess data quality

#Check the 5 first rows
orders.head()

	order_id	user_id	order_number	order_dow	order_hour_of_day	days_since_prior_order
0	2425083	49125	1	2	18	NaN
1	1944304	162867	1	3	17	NaN
2	1201011	147243	14	0	16	3.0
3	1906860	195275	81	1	11	3.0
4	2766469	58222	3	6	11	6.0

#Check the shape of dataset
orders.shape

(200000, 6)

#Info about dataset
orders.info()

<class 'pandas.core.frame.DataFrame'>
RangeIndex: 200000 entries, 0 to 199999
Data columns (total 6 columns):
 #   Column                  Non-Null Count   Dtype  
---  ------                  --------------   -----  
 0   order_id                200000 non-null  int64  
 1   user_id                 200000 non-null  int64  
 2   order_number            200000 non-null  int64  
 3   order_dow               200000 non-null  int64  
 4   order_hour_of_day       200000 non-null  int64  
 5   days_since_prior_order  187746 non-null  float64
dtypes: float64(1), int64(5)
memory usage: 9.2 MB

#Check the 5 first rows
orders_prod.head()

	order_id	product_id	add_to_cart_order	reordered
0	10	24	1	1
1	10	83	2	1
2	10	16	3	0
3	10	24	4	1
4	10	83	5	1

#Check the shape of dataset
orders_prod.shape

(2019501, 4)

#Info about dataset
orders_prod.info()

<class 'pandas.core.frame.DataFrame'>
RangeIndex: 2019501 entries, 0 to 2019500
Data columns (total 4 columns):
 #   Column             Dtype
---  ------             -----
 0   order_id           int64
 1   product_id         int64
 2   add_to_cart_order  int64
 3   reordered          int64
dtypes: int64(4)
memory usage: 61.6 MB

# Replace possible empty values with NaN
orders_prod.replace("", np.nan, inplace=True)
# Function to show missing values and their percentages
def missing_data(df):
    l = []
    for col in df.columns:
        missing = df[col].isnull().sum(axis=0)
        percentage = missing/df.shape[0]
        l.append([col,missing,percentage*100])
        df_missing = pd.DataFrame(l, columns = ['Feature','missing','percentage'])
        df_missing = df_missing.sort_values('missing',axis=0, ascending = False)    
    return df_missing

# Check the percentage of missing values
df_missing = missing_data(orders_prod)
df_missing = df_missing[df_missing['missing']>0]
df_missing

	Feature	missing	percentage

#Check the 5 first rows
departments.head()

	department_id	department
0	1	frozen
1	2	other
2	3	bakery
3	4	produce
4	5	alcohol

#Check the shape of dataset
departments.shape

(21, 2)

#Check the shape of dataset
departments.info()

<class 'pandas.core.frame.DataFrame'>
RangeIndex: 21 entries, 0 to 20
Data columns (total 2 columns):
 #   Column         Non-Null Count  Dtype 
---  ------         --------------  ----- 
 0   department_id  21 non-null     int64 
 1   department     21 non-null     object
dtypes: int64(1), object(1)
memory usage: 464.0+ bytes

#Check the 5 first rows
products.head()

	product_id	department_id	product_name
0	61	19	cookies cakes
1	104	13	spices seasonings
2	94	7	tea
3	38	1	frozen meals
4	5	13	marinades meat preparation

#Check the shape of dataset
products.shape

(134, 3)

#Check the shape of dataset
products.info()

<class 'pandas.core.frame.DataFrame'>
RangeIndex: 134 entries, 0 to 133
Data columns (total 3 columns):
 #   Column         Non-Null Count  Dtype 
---  ------         --------------  ----- 
 0   product_id     134 non-null    int64 
 1   department_id  134 non-null    int64 
 2   product_name   134 non-null    object
dtypes: int64(2), object(1)
memory usage: 3.3+ KB

Customers' behaviors

#Check the 5 first rows
orders.head()

	order_id	user_id	order_number	order_dow	order_hour_of_day	days_since_prior_order
0	2425083	49125	1	2	18	NaN
1	1944304	162867	1	3	17	NaN
2	1201011	147243	14	0	16	3.0
3	1906860	195275	81	1	11	3.0
4	2766469	58222	3	6	11	6.0

#Create a function to return the number of orders by day of week or per hour of the day to be use in the app
def frequent_time(option):
    df = orders
    if option == "Day of week":
        freq = df['order_dow'].value_counts()
    elif option == 'Hour of the day':
        freq = df['order_hour_of_day'].value_counts()
    return freq

#Day of week more frequent
dow_freq = orders['order_dow'].value_counts()
dow_freq

0    35078
1    34348
2    27277
5    26557
6    26096
3    25670
4    24974
Name: order_dow, dtype: int64

#Plotly visualization - Bar plot
#define the data for the visuzalization
data_bar = (dict(type='bar',
                     x=dow_freq.index,
                     y=dow_freq.values,
                     marker_color=' cornflowerblue',
                     showlegend=False
                    )
               )
#Define the layout
layout_bar = dict(title=dict(
                        text='Frequency by day of week' #Set the title
                        ),
                  xaxis=dict(title='Day of week'), #Set the xaxis title
                  yaxis=dict(title='Number of orders'), #Set the yaxis title
                  title_x=0.5 #position of the xaxis  title
                 )
fig_bar = go.Figure(data=data_bar, layout=layout_bar)

fig_bar.show()

#Hour of day more frequent
hod_freq = orders['order_hour_of_day'].value_counts()
hod_freq

10    17102
11    16748
15    16649
14    16600
13    16189
12    15942
16    15928
9     14989
17    13201
18    10716
8     10294
19     8164
20     6209
7      5310
21     4492
22     3731
23     2302
6      1803
0      1311
1       719
5       555
2       429
4       330
3       287
Name: order_hour_of_day, dtype: int64

#Plotly visualization - Bar plot
#define the data for the visuzalization
data_bar = (dict(type='bar',
                     x=hod_freq.index,
                     y=hod_freq.values,
                     marker_color='mediumaquamarine',
                     showlegend=False
                    )
               )
#Define the layout
layout_bar = dict(title=dict(
                        text='Frequency by hour of day'#Set the title
                        ),
                  xaxis=dict(title='Hour of day'), #Set the xaxis title
                  yaxis=dict(title='Number of orders'), #Set the yaxis title
                  title_x=0.5 #position of the xaxis  title
                 )
fig_bar = go.Figure(data=data_bar, layout=layout_bar)

fig_bar.show()

#Create a function with a bar plotly vizualization with the option by user choose 'day of week' or 'hour of the day' 
def update_barplot(option):
    data_bar = (dict(type='bar',
                     x=frequent_time(option).index,
                     y=frequent_time(option).values,
                     marker_color=' cornflowerblue',
                     showlegend=False))  
    layout_bar = dict(title=dict(
                        text=f'Frequency by {option}'),
                  xaxis=dict(title=f'{option}'),
                  yaxis=dict(title='Number of orders'),
                  title_x=0.5)
    fig_bar = go.Figure(data=data_bar, layout=layout_bar)
    return fig_bar

#test the function. Set option = hour of the day
update_barplot("Hour of the day")

#Create the dataframe grouped by days since prior order
prior_orders = orders['days_since_prior_order'].value_counts()
prior_orders 

30.0    20982
7.0     18882
6.0     14262
4.0     13054
3.0     12673
5.0     12508
2.0     11362
8.0     10466
1.0      8756
9.0      6918
14.0     5769
10.0     5739
11.0     4810
13.0     4808
12.0     4453
0.0      4016
15.0     3904
16.0     2660
21.0     2634
17.0     2296
20.0     2172
18.0     2140
19.0     1946
22.0     1907
28.0     1497
23.0     1338
27.0     1239
24.0     1214
25.0     1142
29.0     1130
26.0     1069
Name: days_since_prior_order, dtype: int64

#Create a Plotly Visualization to be included in dashboard - Bar plot
#Define the dataset to be used
df = prior_orders
#Define the data to plot
data_bar = (dict(type='bar',
                     x=df.index,
                     y=df.values,
                     marker_color='lightseagreen',
                     showlegend=False))  
#Define the layout
layout_bar = dict(title=dict(
                        text='Days since prior order'),
                  xaxis=dict(title='Number of days'),
                  yaxis=dict(title='Number of orders'),
                  title_x=0.5)
fig_bar = go.Figure(data=data_bar, layout=layout_bar)
fig_bar.show()

#Create a dataframe grouped by user id
number_orders = orders['user_id'].value_counts()
#Sort the values by the user with highest number of orders
number_orders = number_orders.sort_values(ascending=False,axis=0)
#Reset index
number_orders = number_orders.reset_index()
#Rename columns
number_orders.rename(columns={'index': 'number_user'}, inplace = True)
number_orders.rename(columns={'user_id': 'number_orders'}, inplace = True)
#Group the dataframe by quantity of users according by number of orders placed
number_orders= number_orders.groupby("number_orders")['number_user'].agg(['count'])
#Reset index
number_orders = number_orders.reset_index()
#Show
number_orders

	number_orders	count
0	1	57803
1	2	24686
2	3	11181
3	4	5444
4	5	2836
5	6	1577
6	7	862
7	8	438
8	9	256
9	10	111
10	11	50
11	12	17
12	13	11
13	15	1

##Create a Plotly Visualization to be included in dashboard - Bar plot
#Define the dataset to be used
df = number_orders
#Define the data to plot
data = dict(type='scatter',
                  x=df['number_orders'],
                  y=df['count'],
                  name='Quantity of users by quantity of orders'
                  )
#Define the layout
layout = dict(title=dict(text='Quantity of orders'),
                  xaxis=dict(title='Number of orders'),
                  yaxis=dict(title='Quantity of users')
                  )
#Create the figure
fig_users = go.Figure(data, layout)
fig_users.show()

#Check the first 5 rows
orders_prod.head()

	order_id	product_id	add_to_cart_order	reordered
0	10	24	1	1
1	10	83	2	1
2	10	16	3	0
3	10	24	4	1
4	10	83	5	1

#Create a dataframe to plot the basket size in the dash
#Create the dataframe grouped by number of itens add to cart
avg_basket = orders_prod.groupby("order_id")['add_to_cart_order'].agg(['count'])
#Rename the column
avg_basket = avg_basket.rename({"count":"basket_size"}, axis=1)
#Reset the index the column
avg_basket.reset_index(inplace = True)
#Create the dataframe grouped by number of itens add to cart
avg_basket= avg_basket.groupby('basket_size')["order_id"].agg(['count'])
#Rename the column
avg_basket = avg_basket.rename({"count":"number_of_orders"}, axis=1)
#Reset the index the column
avg_basket.reset_index(inplace = True)
#Sort by number of orders according with the basket size.
avg_basket.sort_values(by='number_of_orders', ascending=False, inplace=True)
#Filter the 25 basket sizes that most appear. 
avg_basket_top25 = avg_basket[0:25]
#Show
avg_basket_top25

	basket_size	number_of_orders
4	5	14242
5	6	14146
3	4	13760
6	7	13695
7	8	12741
2	3	12737
1	2	11654
8	9	11497
9	10	10227
0	1	9866
10	11	9100
11	12	8271
12	13	7154
13	14	6361
14	15	5715
15	16	5080
16	17	4433
17	18	3825
18	19	3451
19	20	2991
20	21	2646
21	22	2260
22	23	1929
23	24	1716
24	25	1556

#Create a bar plot to show the basket size
#define the data
data = dict(type='bar',
                  x=avg_basket_top25['basket_size'],
                  y=avg_basket_top25['number_of_orders'],
                  name='Basket Size'
                  )
#define the layout
layout = dict(title=dict(text='Average Basket size'),
                  xaxis=dict(title='Basket Size'),
                  yaxis=dict(title='Number of orders')
                  )
#create the fig
avgbasket_fig = go.Figure(data, layout)
avgbasket_fig.show()

Products and departments most consumed

#Check the first  rows
orders_prod.head()

	order_id	product_id	add_to_cart_order	reordered
0	10	24	1	1
1	10	83	2	1
2	10	16	3	0
3	10	24	4	1
4	10	83	5	1

#Create a dataframe to merge the datasets by product and department
df_merge = pd.merge(orders_prod, products, how='left', on='product_id')
df_merge = pd.merge(df_merge, departments, how='left', on='department_id')
df_merge.head()

	order_id	product_id	add_to_cart_order	reordered	department_id	product_name	department
0	10	24	1	1	4	fresh fruits	produce
1	10	83	2	1	4	fresh vegetables	produce
2	10	16	3	0	4	fresh herbs	produce
3	10	24	4	1	4	fresh fruits	produce
4	10	83	5	1	4	fresh vegetables	produce

#Describe the dataframe
df_merge.astype(object).describe()

	order_id	product_id	add_to_cart_order	reordered	department_id	product_name	department
count	2019501	2019501	2019501	2019501	2019501	2019501	2019501
unique	200000	134	137	2	21	134	21
top	790903	24	1	1	4	fresh fruits	produce
freq	137	226039	200000	1190986	588996	226039	588996

#Products more frequent
prod_freq = df_merge['product_name'].value_counts()
prod_freq

fresh fruits                     226039
fresh vegetables                 212611
packaged vegetables fruits       109596
yogurt                            90751
packaged cheese                   61502
milk                              55150
water seltzer sparkling water     52564
chips pretzels                    45306
soy lactosefree                   39389
bread                             36381
refrigerated                      35893
frozen produce                    32432
ice cream ice                     31323
energy granola bars               28639
crackers                          28574
eggs                              27986
lunch meat                        24470
frozen meals                      24449
cereal                            23754
baby food formula                 23355
fresh herbs                       23342
soft drinks                       22428
fresh dips tapenades              22175
soup broth bouillon               21540
juice nectars                     20715
baking ingredients                20137
cream                             19786
other creams cheeses              19091
hot dogs bacon sausage            19037
nuts seeds dried fruit            19026
candy chocolate                   18735
spreads                           18149
canned jarred vegetables          18025
packaged produce                  17408
canned meals beans                16818
dry pasta                         16414
butter                            15735
tea                               15733
paper goods                       15422
breakfast bakery                  15357
oils vinegars                     15213
cookies cakes                     14745
frozen breakfast                  14346
pasta sauce                       13771
condiments                        13760
spices seasonings                 13067
coffee                            12823
instant foods                     12651
frozen appetizers sides           12178
tortillas flat bread              12082
fruit vegetable snacks            10931
asian foods                       10426
popcorn jerky                     10415
frozen pizza                      10124
hot cereal pancake mixes           9820
grains rice dried goods            8878
poultry counter                    8131
tofu meat alternatives             8003
packaged poultry                   7467
cleaning products                  7429
buns rolls                         6949
pickled goods olives               6925
preserved dips spreads             6866
doughs gelatins bake mixes         6693
energy sports drinks               6638
granola                            6410
frozen vegan vegetarian            6321
prepared meals                     6144
salad dressing toppings            6009
laundry                            5904
dish detergents                    5867
canned fruit applesauce            5458
specialty cheeses                  5102
missing                            4749
latino foods                       4652
breakfast bars pastries            4621
meat counter                       4472
frozen meat seafood                4408
prepared soups salads              4384
canned meat seafood                4212
honeys syrups nectars              4156
food storage                       4144
oral hygiene                       4018
soap                               3918
marinades meat preparation         3836
cat food care                      3835
beers coolers                      3002
vitamins supplements               2912
plates bowls cups flatware         2671
body lotions soap                  2507
frozen breads doughs               2486
refrigerated pudding desserts      2423
fresh pasta                        2340
protein meal replacements          2257
other                              2240
trail mix snack mix                2238
bakery desserts                    2214
dog food care                      2178
red wines                          2135
trash bags liners                  2020
packaged meat                      2020
hair care                          1909
white wines                        1893
seafood counter                    1843
spirits                            1795
digestion                          1727
cold flu allergy                   1589
diapers wipes                      1566
baking supplies decor              1451
mint gum                           1377
cocoa drink mixes                  1332
packaged seafood                   1301
feminine care                      1296
air fresheners candles             1258
muscles joints pain relief         1256
frozen dessert                     1190
more household                     1170
bulk grains rice dried goods       1074
bulk dried fruits vegetables       1059
indian foods                        963
deodorants                          924
facial care                         843
ice cream toppings                  706
kosher foods                        697
first aid                           693
skin care                           654
shave needs                         646
specialty wines champagnes          614
eye ear care                        598
kitchen supplies                    561
baby bath body care                 515
baby accessories                    504
beauty                              387
frozen juice                        279
Name: product_name, dtype: int64

#Plotly visualization
#Plot number of itens sold by product - Treemap - only 30 products with highest number of itens 
#Define the dataset
df = prod_freq
#Define the data
treemap_trace = go.Treemap(labels=df.index[0:30], parents=[""] * len(df.index), values=df.values[0:30])
#Define the layout
treemap_layout = go.Layout( {"margin": dict(t=35, b=10, l=5, r=5, pad=4)},title=dict(text='Itens sold by product') )
#Create the figure
treemap_figure = go.Figure(data=treemap_trace, layout=treemap_layout)
treemap_figure.show()

# Create dataframe to plot the number of orders by products
#Drop the columns not useful
df1 = df_merge.drop(["product_id", "department_id", 'add_to_cart_order','reordered','department'], axis=1)
#Pivot the data - lines as orders and products as columns
df_pivot = pd.pivot_table(df1, index='order_id', columns='product_name', 
                    aggfunc=lambda x: 1 if len(x)>0 else 0).fillna(0)

#Transpose the pivot
df_pivot =df_pivot.T
#Create a column to count number of orders that the product appears
df_pivot['sum'] = df_pivot[df_pivot.columns].apply(lambda x: sum(x), axis = 1)
#Sort by number of orders. 
df_pivot.sort_values(by='sum', ascending=False, inplace=True)
df_pivot['sum']

product_name
fresh fruits                     111199.0
fresh vegetables                  88872.0
packaged vegetables fruits        73083.0
yogurt                            52735.0
milk                              48665.0
packaged cheese                   46199.0
water seltzer sparkling water     38601.0
chips pretzels                    33887.0
soy lactosefree                   33671.0
bread                             32773.0
eggs                              27298.0
refrigerated                      26808.0
frozen produce                    24516.0
crackers                          22994.0
ice cream ice                     22102.0
lunch meat                        20778.0
fresh dips tapenades              19641.0
fresh herbs                       18601.0
cereal                            18512.0
cream                             18321.0
juice nectars                     17879.0
soft drinks                       17462.0
energy granola bars               17309.0
other creams cheeses              17297.0
hot dogs bacon sausage            16838.0
soup broth bouillon               16673.0
nuts seeds dried fruit            16045.0
spreads                           15637.0
baking ingredients                15327.0
butter                            14866.0
frozen meals                      14866.0
canned jarred vegetables          14378.0
dry pasta                         14011.0
canned meals beans                13941.0
candy chocolate                   13861.0
breakfast bakery                  13553.0
oils vinegars                     13470.0
paper goods                       12715.0
pasta sauce                       12532.0
packaged produce                  12454.0
frozen breakfast                  12233.0
cookies cakes                     11945.0
condiments                        11893.0
tea                               11402.0
tortillas flat bread              11291.0
coffee                            11130.0
spices seasonings                 10433.0
instant foods                     10399.0
frozen appetizers sides           10375.0
popcorn jerky                      9282.0
fruit vegetable snacks             9217.0
baby food formula                  9071.0
hot cereal pancake mixes           9005.0
asian foods                        8666.0
frozen pizza                       8613.0
grains rice dried goods            8037.0
poultry counter                    7796.0
packaged poultry                   7242.0
tofu meat alternatives             6572.0
preserved dips spreads             6441.0
buns rolls                         6420.0
pickled goods olives               6326.0
doughs gelatins bake mixes         5653.0
granola                            5630.0
cleaning products                  5560.0
dish detergents                    5444.0
prepared meals                     5417.0
salad dressing toppings            5304.0
laundry                            5017.0
frozen vegan vegetarian            4979.0
energy sports drinks               4882.0
canned fruit applesauce            4832.0
specialty cheeses                  4805.0
meat counter                       4371.0
latino foods                       4255.0
frozen meat seafood                4205.0
missing                            4135.0
honeys syrups nectars              4003.0
canned meat seafood                3863.0
prepared soups salads              3849.0
breakfast bars pastries            3755.0
marinades meat preparation         3582.0
oral hygiene                       3523.0
food storage                       3497.0
soap                               3382.0
vitamins supplements               2571.0
frozen breads doughs               2425.0
plates bowls cups flatware         2258.0
body lotions soap                  2193.0
fresh pasta                        2171.0
trail mix snack mix                2159.0
other                              2148.0
cat food care                      2123.0
bakery desserts                    2092.0
refrigerated pudding desserts      2042.0
protein meal replacements          2021.0
packaged meat                      1995.0
trash bags liners                  1920.0
beers coolers                      1857.0
seafood counter                    1822.0
dog food care                      1640.0
digestion                          1617.0
red wines                          1548.0
white wines                        1532.0
hair care                          1505.0
spirits                            1453.0
diapers wipes                      1413.0
cold flu allergy                   1295.0
baking supplies decor              1290.0
packaged seafood                   1276.0
muscles joints pain relief         1196.0
cocoa drink mixes                  1161.0
frozen dessert                     1143.0
mint gum                           1094.0
feminine care                      1091.0
more household                     1084.0
bulk dried fruits vegetables       1053.0
bulk grains rice dried goods       1050.0
air fresheners candles             1033.0
deodorants                          868.0
indian foods                        795.0
facial care                         743.0
kosher foods                        644.0
ice cream toppings                  642.0
skin care                           605.0
shave needs                         605.0
first aid                           597.0
eye ear care                        563.0
specialty wines champagnes          563.0
kitchen supplies                    543.0
baby accessories                    498.0
baby bath body care                 476.0
beauty                              354.0
frozen juice                        247.0
Name: sum, dtype: float64

#Filter the ones that appears at least in 10% of orders
#Plotly number of orders by product - Treemap
#Define the dataset
df = df_pivot
#Define the data
treemap_trace = go.Treemap(labels=df.index[0:16], parents=[""] * len(df.index), values=df['sum'][0:16])
#Define the layout
treemap_layout = go.Layout({"margin": dict(t=35, b=10, l=5, r=5, pad=4)}, title=dict(text='Number of orders by product') )
#Create the figure
treemap_prod = go.Figure(data=treemap_trace, layout=treemap_layout)
treemap_prod.show()

#Create a list with the products that appear in both (highest itens sold and 10% of orders)
list1 = prod_freq.index[0:30]
list2 = df_pivot.index[0:16]
list_both = []
for variable in list1:
    if variable in list2:
        list_both.append(variable)
list_both

#With this list we can analyse 55% of the total of itens sold and that appears at least in 10% of orders;

['fresh fruits',
 'fresh vegetables',
 'packaged vegetables fruits',
 'yogurt',
 'packaged cheese',
 'milk',
 'water seltzer sparkling water',
 'chips pretzels',
 'soy lactosefree',
 'bread',
 'refrigerated',
 'frozen produce',
 'ice cream ice',
 'crackers',
 'eggs',
 'lunch meat']

The criteria used to select the products that have highest number of itens sold and appears in the most orders. We are going to demonstrated that few products represents more than 50% sales and appears in 10% of orders. The other products have low representativeness.

#Create a dataframe to count the number of itens by product
prod_participation = df_merge.groupby("product_name")["reordered"].agg(['count'])
#Rename the columns
prod_participation = prod_participation.rename({"count":"ordered_sum"}, axis=1)
#Reset index
prod_participation.reset_index(inplace = True)
#Sort values by the most ordered
prod_participation.sort_values(by='ordered_sum', ascending=False, inplace=True)
#Create a % of itens sold of each product over the total
prod_participation['percentage'] = round(prod_participation.ordered_sum /prod_participation.ordered_sum.sum() *100,4)
#Create a cummulative % of itens sold
prod_participation['cumpercentage'] = prod_participation['percentage'].cumsum()
prod_participation

	product_name	ordered_sum	percentage	cumpercentage
50	fresh fruits	226039	11.1928	11.1928
53	fresh vegetables	212611	10.5279	21.7207
98	packaged vegetables fruits	109596	5.4269	27.1476
133	yogurt	90751	4.4937	31.6413
93	packaged cheese	61502	3.0454	34.6867
83	milk	55150	2.7309	37.4176
131	water seltzer sparkling water	52564	2.6028	40.0204
25	chips pretzels	45306	2.2434	42.2638
119	soy lactosefree	39389	1.9504	44.2142
11	bread	36381	1.8015	46.0157
110	refrigerated	35893	1.7773	47.7930
62	frozen produce	32432	1.6059	49.3989
71	ice cream ice	31323	1.5510	50.9499
42	energy granola bars	28639	1.4181	52.3680
32	crackers	28574	1.4149	53.7829
41	eggs	27986	1.3858	55.1687
80	lunch meat	24470	1.2117	56.3804
59	frozen meals	24449	1.2106	57.5910
24	cereal	23754	1.1762	58.7672
4	baby food formula	23355	1.1565	59.9237
51	fresh herbs	23342	1.1558	61.0795
117	soft drinks	22428	1.1106	62.1901
49	fresh dips tapenades	22175	1.0980	63.2881
118	soup broth bouillon	21540	1.0666	64.3547
75	juice nectars	20715	1.0257	65.3804
6	baking ingredients	20137	0.9971	66.3775
33	cream	19786	0.9797	67.3572
92	other creams cheeses	19091	0.9453	68.3025
70	hot dogs bacon sausage	19037	0.9427	69.2452
88	nuts seeds dried fruit	19026	0.9421	70.1873
18	candy chocolate	18735	0.9277	71.1150
124	spreads	18149	0.8987	72.0137
20	canned jarred vegetables	18025	0.8925	72.9062
96	packaged produce	17408	0.8620	73.7682
21	canned meals beans	16818	0.8328	74.6010
40	dry pasta	16414	0.8128	75.4138
17	butter	15735	0.7792	76.1930
125	tea	15733	0.7791	76.9721
99	paper goods	15422	0.7637	77.7358
12	breakfast bakery	15357	0.7604	78.4962
89	oils vinegars	15213	0.7533	79.2495
31	cookies cakes	14745	0.7301	79.9796
56	frozen breakfast	14346	0.7104	80.6900
100	pasta sauce	13771	0.6819	81.3719
30	condiments	13760	0.6814	82.0533
122	spices seasonings	13067	0.6470	82.7003
28	coffee	12823	0.6350	83.3353
74	instant foods	12651	0.6264	83.9617
54	frozen appetizers sides	12178	0.6030	84.5647
127	tortillas flat bread	12082	0.5983	85.1630
64	fruit vegetable snacks	10931	0.5413	85.7043
1	asian foods	10426	0.5163	86.2206
103	popcorn jerky	10415	0.5157	86.7363
61	frozen pizza	10124	0.5013	87.2376
69	hot cereal pancake mixes	9820	0.4863	87.7239
65	grains rice dried goods	8878	0.4396	88.1635
104	poultry counter	8131	0.4026	88.5661
126	tofu meat alternatives	8003	0.3963	88.9624
95	packaged poultry	7467	0.3697	89.3321
26	cleaning products	7429	0.3679	89.7000
16	buns rolls	6949	0.3441	90.0441
101	pickled goods olives	6925	0.3429	90.3870
107	preserved dips spreads	6866	0.3400	90.7270
39	doughs gelatins bake mixes	6693	0.3314	91.0584
43	energy sports drinks	6638	0.3287	91.3871
66	granola	6410	0.3174	91.7045
63	frozen vegan vegetarian	6321	0.3130	92.0175
105	prepared meals	6144	0.3042	92.3217
112	salad dressing toppings	6009	0.2975	92.6192
79	laundry	5904	0.2923	92.9115
37	dish detergents	5867	0.2905	93.2020
19	canned fruit applesauce	5458	0.2703	93.4723
120	specialty cheeses	5102	0.2526	93.7249
85	missing	4749	0.2352	93.9601
78	latino foods	4652	0.2304	94.1905
13	breakfast bars pastries	4621	0.2288	94.4193
82	meat counter	4472	0.2214	94.6407
60	frozen meat seafood	4408	0.2183	94.8590
106	prepared soups salads	4384	0.2171	95.0761
22	canned meat seafood	4212	0.2086	95.2847
68	honeys syrups nectars	4156	0.2058	95.4905
48	food storage	4144	0.2052	95.6957
90	oral hygiene	4018	0.1990	95.8947
116	soap	3918	0.1940	96.0887
81	marinades meat preparation	3836	0.1899	96.2786
23	cat food care	3835	0.1899	96.4685
9	beers coolers	3002	0.1487	96.6172
130	vitamins supplements	2912	0.1442	96.7614
102	plates bowls cups flatware	2671	0.1323	96.8937
10	body lotions soap	2507	0.1241	97.0178
55	frozen breads doughs	2486	0.1231	97.1409
111	refrigerated pudding desserts	2423	0.1200	97.2609
52	fresh pasta	2340	0.1159	97.3768
108	protein meal replacements	2257	0.1118	97.4886
91	other	2240	0.1109	97.5995
128	trail mix snack mix	2238	0.1108	97.7103
5	bakery desserts	2214	0.1096	97.8199
38	dog food care	2178	0.1078	97.9277
109	red wines	2135	0.1057	98.0334
94	packaged meat	2020	0.1000	98.1334
129	trash bags liners	2020	0.1000	98.2334
67	hair care	1909	0.0945	98.3279
132	white wines	1893	0.0937	98.4216
113	seafood counter	1843	0.0913	98.5129
123	spirits	1795	0.0889	98.6018
36	digestion	1727	0.0855	98.6873
29	cold flu allergy	1589	0.0787	98.7660
35	diapers wipes	1566	0.0775	98.8435
7	baking supplies decor	1451	0.0718	98.9153
84	mint gum	1377	0.0682	98.9835
27	cocoa drink mixes	1332	0.0660	99.0495
97	packaged seafood	1301	0.0644	99.1139
46	feminine care	1296	0.0642	99.1781
0	air fresheners candles	1258	0.0623	99.2404
87	muscles joints pain relief	1256	0.0622	99.3026
57	frozen dessert	1190	0.0589	99.3615
86	more household	1170	0.0579	99.4194
15	bulk grains rice dried goods	1074	0.0532	99.4726
14	bulk dried fruits vegetables	1059	0.0524	99.5250
73	indian foods	963	0.0477	99.5727
34	deodorants	924	0.0458	99.6185
45	facial care	843	0.0417	99.6602
72	ice cream toppings	706	0.0350	99.6952
77	kosher foods	697	0.0345	99.7297
47	first aid	693	0.0343	99.7640
115	skin care	654	0.0324	99.7964
114	shave needs	646	0.0320	99.8284
121	specialty wines champagnes	614	0.0304	99.8588
44	eye ear care	598	0.0296	99.8884
76	kitchen supplies	561	0.0278	99.9162
3	baby bath body care	515	0.0255	99.9417
2	baby accessories	504	0.0250	99.9667
8	beauty	387	0.0192	99.9859
58	frozen juice	279	0.0138	99.9997

#Create a dataframe only with number of orders by product and the product name
df_pivot2 = df_pivot.copy()
df_pivot2.reset_index(inplace = True)
df_pivot2 = df_pivot2[['product_name','sum']]

#Create a dataframe to merge number of itens sold with number of orders by product
prod_participation2 = pd.merge(prod_participation, df_pivot2, how='left', on='product_name')
prod_participation2['orders_percentage'] = (prod_participation2['sum']/200000)*100
prod_participation2

	product_name	ordered_sum	percentage	cumpercentage	sum	orders_percentage
0	fresh fruits	226039	11.1928	11.1928	111199.0	55.5995
1	fresh vegetables	212611	10.5279	21.7207	88872.0	44.4360
2	packaged vegetables fruits	109596	5.4269	27.1476	73083.0	36.5415
3	yogurt	90751	4.4937	31.6413	52735.0	26.3675
4	packaged cheese	61502	3.0454	34.6867	46199.0	23.0995
5	milk	55150	2.7309	37.4176	48665.0	24.3325
6	water seltzer sparkling water	52564	2.6028	40.0204	38601.0	19.3005
7	chips pretzels	45306	2.2434	42.2638	33887.0	16.9435
8	soy lactosefree	39389	1.9504	44.2142	33671.0	16.8355
9	bread	36381	1.8015	46.0157	32773.0	16.3865
10	refrigerated	35893	1.7773	47.7930	26808.0	13.4040
11	frozen produce	32432	1.6059	49.3989	24516.0	12.2580
12	ice cream ice	31323	1.5510	50.9499	22102.0	11.0510
13	energy granola bars	28639	1.4181	52.3680	17309.0	8.6545
14	crackers	28574	1.4149	53.7829	22994.0	11.4970
15	eggs	27986	1.3858	55.1687	27298.0	13.6490
16	lunch meat	24470	1.2117	56.3804	20778.0	10.3890
17	frozen meals	24449	1.2106	57.5910	14866.0	7.4330
18	cereal	23754	1.1762	58.7672	18512.0	9.2560
19	baby food formula	23355	1.1565	59.9237	9071.0	4.5355
20	fresh herbs	23342	1.1558	61.0795	18601.0	9.3005
21	soft drinks	22428	1.1106	62.1901	17462.0	8.7310
22	fresh dips tapenades	22175	1.0980	63.2881	19641.0	9.8205
23	soup broth bouillon	21540	1.0666	64.3547	16673.0	8.3365
24	juice nectars	20715	1.0257	65.3804	17879.0	8.9395
25	baking ingredients	20137	0.9971	66.3775	15327.0	7.6635
26	cream	19786	0.9797	67.3572	18321.0	9.1605
27	other creams cheeses	19091	0.9453	68.3025	17297.0	8.6485
28	hot dogs bacon sausage	19037	0.9427	69.2452	16838.0	8.4190
29	nuts seeds dried fruit	19026	0.9421	70.1873	16045.0	8.0225
30	candy chocolate	18735	0.9277	71.1150	13861.0	6.9305
31	spreads	18149	0.8987	72.0137	15637.0	7.8185
32	canned jarred vegetables	18025	0.8925	72.9062	14378.0	7.1890
33	packaged produce	17408	0.8620	73.7682	12454.0	6.2270
34	canned meals beans	16818	0.8328	74.6010	13941.0	6.9705
35	dry pasta	16414	0.8128	75.4138	14011.0	7.0055
36	butter	15735	0.7792	76.1930	14866.0	7.4330
37	tea	15733	0.7791	76.9721	11402.0	5.7010
38	paper goods	15422	0.7637	77.7358	12715.0	6.3575
39	breakfast bakery	15357	0.7604	78.4962	13553.0	6.7765
40	oils vinegars	15213	0.7533	79.2495	13470.0	6.7350
41	cookies cakes	14745	0.7301	79.9796	11945.0	5.9725
42	frozen breakfast	14346	0.7104	80.6900	12233.0	6.1165
43	pasta sauce	13771	0.6819	81.3719	12532.0	6.2660
44	condiments	13760	0.6814	82.0533	11893.0	5.9465
45	spices seasonings	13067	0.6470	82.7003	10433.0	5.2165
46	coffee	12823	0.6350	83.3353	11130.0	5.5650
47	instant foods	12651	0.6264	83.9617	10399.0	5.1995
48	frozen appetizers sides	12178	0.6030	84.5647	10375.0	5.1875
49	tortillas flat bread	12082	0.5983	85.1630	11291.0	5.6455
50	fruit vegetable snacks	10931	0.5413	85.7043	9217.0	4.6085
51	asian foods	10426	0.5163	86.2206	8666.0	4.3330
52	popcorn jerky	10415	0.5157	86.7363	9282.0	4.6410
53	frozen pizza	10124	0.5013	87.2376	8613.0	4.3065
54	hot cereal pancake mixes	9820	0.4863	87.7239	9005.0	4.5025
55	grains rice dried goods	8878	0.4396	88.1635	8037.0	4.0185
56	poultry counter	8131	0.4026	88.5661	7796.0	3.8980
57	tofu meat alternatives	8003	0.3963	88.9624	6572.0	3.2860
58	packaged poultry	7467	0.3697	89.3321	7242.0	3.6210
59	cleaning products	7429	0.3679	89.7000	5560.0	2.7800
60	buns rolls	6949	0.3441	90.0441	6420.0	3.2100
61	pickled goods olives	6925	0.3429	90.3870	6326.0	3.1630
62	preserved dips spreads	6866	0.3400	90.7270	6441.0	3.2205
63	doughs gelatins bake mixes	6693	0.3314	91.0584	5653.0	2.8265
64	energy sports drinks	6638	0.3287	91.3871	4882.0	2.4410
65	granola	6410	0.3174	91.7045	5630.0	2.8150
66	frozen vegan vegetarian	6321	0.3130	92.0175	4979.0	2.4895
67	prepared meals	6144	0.3042	92.3217	5417.0	2.7085
68	salad dressing toppings	6009	0.2975	92.6192	5304.0	2.6520
69	laundry	5904	0.2923	92.9115	5017.0	2.5085
70	dish detergents	5867	0.2905	93.2020	5444.0	2.7220
71	canned fruit applesauce	5458	0.2703	93.4723	4832.0	2.4160
72	specialty cheeses	5102	0.2526	93.7249	4805.0	2.4025
73	missing	4749	0.2352	93.9601	4135.0	2.0675
74	latino foods	4652	0.2304	94.1905	4255.0	2.1275
75	breakfast bars pastries	4621	0.2288	94.4193	3755.0	1.8775
76	meat counter	4472	0.2214	94.6407	4371.0	2.1855
77	frozen meat seafood	4408	0.2183	94.8590	4205.0	2.1025
78	prepared soups salads	4384	0.2171	95.0761	3849.0	1.9245
79	canned meat seafood	4212	0.2086	95.2847	3863.0	1.9315
80	honeys syrups nectars	4156	0.2058	95.4905	4003.0	2.0015
81	food storage	4144	0.2052	95.6957	3497.0	1.7485
82	oral hygiene	4018	0.1990	95.8947	3523.0	1.7615
83	soap	3918	0.1940	96.0887	3382.0	1.6910
84	marinades meat preparation	3836	0.1899	96.2786	3582.0	1.7910
85	cat food care	3835	0.1899	96.4685	2123.0	1.0615
86	beers coolers	3002	0.1487	96.6172	1857.0	0.9285
87	vitamins supplements	2912	0.1442	96.7614	2571.0	1.2855
88	plates bowls cups flatware	2671	0.1323	96.8937	2258.0	1.1290
89	body lotions soap	2507	0.1241	97.0178	2193.0	1.0965
90	frozen breads doughs	2486	0.1231	97.1409	2425.0	1.2125
91	refrigerated pudding desserts	2423	0.1200	97.2609	2042.0	1.0210
92	fresh pasta	2340	0.1159	97.3768	2171.0	1.0855
93	protein meal replacements	2257	0.1118	97.4886	2021.0	1.0105
94	other	2240	0.1109	97.5995	2148.0	1.0740
95	trail mix snack mix	2238	0.1108	97.7103	2159.0	1.0795
96	bakery desserts	2214	0.1096	97.8199	2092.0	1.0460
97	dog food care	2178	0.1078	97.9277	1640.0	0.8200
98	red wines	2135	0.1057	98.0334	1548.0	0.7740
99	packaged meat	2020	0.1000	98.1334	1995.0	0.9975
100	trash bags liners	2020	0.1000	98.2334	1920.0	0.9600
101	hair care	1909	0.0945	98.3279	1505.0	0.7525
102	white wines	1893	0.0937	98.4216	1532.0	0.7660
103	seafood counter	1843	0.0913	98.5129	1822.0	0.9110
104	spirits	1795	0.0889	98.6018	1453.0	0.7265
105	digestion	1727	0.0855	98.6873	1617.0	0.8085
106	cold flu allergy	1589	0.0787	98.7660	1295.0	0.6475
107	diapers wipes	1566	0.0775	98.8435	1413.0	0.7065
108	baking supplies decor	1451	0.0718	98.9153	1290.0	0.6450
109	mint gum	1377	0.0682	98.9835	1094.0	0.5470
110	cocoa drink mixes	1332	0.0660	99.0495	1161.0	0.5805
111	packaged seafood	1301	0.0644	99.1139	1276.0	0.6380
112	feminine care	1296	0.0642	99.1781	1091.0	0.5455
113	air fresheners candles	1258	0.0623	99.2404	1033.0	0.5165
114	muscles joints pain relief	1256	0.0622	99.3026	1196.0	0.5980
115	frozen dessert	1190	0.0589	99.3615	1143.0	0.5715
116	more household	1170	0.0579	99.4194	1084.0	0.5420
117	bulk grains rice dried goods	1074	0.0532	99.4726	1050.0	0.5250
118	bulk dried fruits vegetables	1059	0.0524	99.5250	1053.0	0.5265
119	indian foods	963	0.0477	99.5727	795.0	0.3975
120	deodorants	924	0.0458	99.6185	868.0	0.4340
121	facial care	843	0.0417	99.6602	743.0	0.3715
122	ice cream toppings	706	0.0350	99.6952	642.0	0.3210
123	kosher foods	697	0.0345	99.7297	644.0	0.3220
124	first aid	693	0.0343	99.7640	597.0	0.2985
125	skin care	654	0.0324	99.7964	605.0	0.3025
126	shave needs	646	0.0320	99.8284	605.0	0.3025
127	specialty wines champagnes	614	0.0304	99.8588	563.0	0.2815
128	eye ear care	598	0.0296	99.8884	563.0	0.2815
129	kitchen supplies	561	0.0278	99.9162	543.0	0.2715
130	baby bath body care	515	0.0255	99.9417	476.0	0.2380
131	baby accessories	504	0.0250	99.9667	498.0	0.2490
132	beauty	387	0.0192	99.9859	354.0	0.1770
133	frozen juice	279	0.0138	99.9997	247.0	0.1235

#Plot the graphic 2D
fig, ax = plt.subplots(figsize=(8,5))
#Set the data of each line
ax.plot( prod_participation2.index.tolist(), prod_participation2['cumpercentage'], '-', color='blue', label="cumm percentage of itens sold") 
ax.plot( prod_participation2.index.tolist(), prod_participation2['orders_percentage'], '--', color='red', label="test1") 
#Formt the grid
ax.grid(True)
#Plot layout
ax.set( xlabel='Number of Products', ylabel='% Participation',
       title='Products participation')
ax.set_xticks([0, 20, 40,60,80,100,120,140])
ax.set_yticks([0, 10, 20, 30, 40,50,60,70,80,90,100])

plt.show()

#Departments more frequent by itens sold
#Create a dataframe grouped by department
grouped = df_merge.groupby("department")["order_id"].agg(['count'])
#Rename columsn
grouped = grouped.rename({"count":"Ordersitens_bydept"}, axis=1)
#Reset index
grouped.reset_index(inplace = True)
#Create a column with the % of participation of each department in total itens sold
grouped['Ratio'] = grouped["Ordersitens_bydept"].apply(lambda x: x /grouped['Ordersitens_bydept'].sum())
#Sort by the departmens with more itens sold
grouped.sort_values(by='Ordersitens_bydept', ascending=False, inplace=True)
grouped

	department	Ordersitens_bydept	Ratio
19	produce	588996	0.291654
7	dairy eggs	336915	0.166831
20	snacks	180692	0.089474
3	beverages	168126	0.083251
10	frozen	139536	0.069094
16	pantry	116262	0.057570
2	bakery	72983	0.036139
6	canned goods	66053	0.032708
8	deli	65176	0.032273
9	dry goods pasta	54054	0.026766
11	household	46446	0.022999
4	breakfast	44605	0.022087
13	meat seafood	44271	0.021922
17	personal care	28134	0.013931
1	babies	25940	0.012845
12	international	16738	0.008288
0	alcohol	9439	0.004674
18	pets	6013	0.002977
14	missing	4749	0.002352
15	other	2240	0.001109
5	bulk	2133	0.001056

#Group some departments with low participation in one label callled others
grouped['department'] = grouped['department'].replace(['personal care', 'babies', 'international','alcohol','pets', 
                                                       'missing','other','bulk'],
                                                      'others')
grouped

	department	Ordersitens_bydept	Ratio
19	produce	588996	0.291654
7	dairy eggs	336915	0.166831
20	snacks	180692	0.089474
3	beverages	168126	0.083251
10	frozen	139536	0.069094
16	pantry	116262	0.057570
2	bakery	72983	0.036139
6	canned goods	66053	0.032708
8	deli	65176	0.032273
9	dry goods pasta	54054	0.026766
11	household	46446	0.022999
4	breakfast	44605	0.022087
13	meat seafood	44271	0.021922
17	others	28134	0.013931
1	others	25940	0.012845
12	others	16738	0.008288
0	others	9439	0.004674
18	others	6013	0.002977
14	others	4749	0.002352
15	others	2240	0.001109
5	others	2133	0.001056

#Plotly % of itens sold by department - Pie plot
#Define the dataset
df = grouped
#Define the labels and the data
department_labels = df['department']
department_values = df['Ratio']
department_data = dict(type='pie',labels=department_labels,
                        values=department_values,)
#Define the layout
department_layout = dict(title=dict(text='Orders itens by department - % share'))
#Create the figure
department_fig = go.Figure(data= department_data, layout=department_layout)
department_fig.show()

# Create dataframe to plot the number of orders by departments
df2 = df_merge.drop(["product_id", "department_id", 'add_to_cart_order','reordered','product_name'], axis=1)
# Pivot the data - lines as orders and products as columns
df_pivot_dept = pd.pivot_table(df2, index='order_id', columns='department', 
                    aggfunc=lambda x: 1 if len(x)>0 else 0).fillna(0)
#Transpose the pivot
df_pivot_dept =df_pivot_dept.T
#Create a column to count number of orders that the department appears
df_pivot_dept['sum'] = df_pivot_dept[df_pivot_dept.columns].apply(lambda x: sum(x), axis = 1)
#Sort by number of orders. 
df_pivot_dept.sort_values(by='sum', ascending=False, inplace=True)
#Show
df_pivot_dept['sum']

department
produce            149613.0
dairy eggs         135120.0
beverages           91238.0
snacks              86765.0
frozen              73506.0
pantry              69509.0
bakery              54713.0
deli                47777.0
canned goods        42255.0
dry goods pasta     37238.0
meat seafood        35907.0
breakfast           32699.0
household           29535.0
personal care       19896.0
international       13798.0
babies              10910.0
alcohol              5201.0
missing              4135.0
pets                 3678.0
other                2148.0
bulk                 2079.0
Name: sum, dtype: float64

#Filter the  deparments that appears at least in 5% of orders
#Plotly number of orders by deparment
#Define the dataset
df = df_pivot_dept
#Define the data
treemap_trace = go.Treemap(labels=df.index[0:16], parents=[""] * len(df.index), values=df['sum'][0:16])
#Define the layout
treemap_layout = go.Layout({"margin": dict(t=10, b=10, l=5, r=5, pad=4)} )
#Create the figure
treemap_dept = go.Figure(data=treemap_trace, layout=treemap_layout)
treemap_dept.show()

#Number of products reordered or not
orders_prod['reordered'].value_counts()

1    1190986
0     828515
Name: reordered, dtype: int64

#Create a dataframe groupped by reordered or not
prod_reord = df_merge.groupby("product_name")["reordered"].agg(['count','sum'])
#Rename the columns
prod_reord = prod_reord.rename({"count":"ordered_sum"}, axis=1)
prod_reord = prod_reord.rename({"sum":"reordered_sum"}, axis=1)
#Reset index
prod_reord.reset_index(inplace = True)
#Create a new column to calculate the reordered probabibility (% of reordered)
prod_reord['reorder_probability'] = (prod_reord["reordered_sum"]/prod_reord['ordered_sum'])*100
#Sort values to show the most reordered
prod_reord.sort_values(by='reorder_probability', ascending=False, inplace=True)
prod_reord

	product_name	ordered_sum	reordered_sum	reorder_probability
83	milk	55150	43162	78.262919
131	water seltzer sparkling water	52564	38467	73.181265
50	fresh fruits	226039	162355	71.826101
41	eggs	27986	19798	70.742514
119	soy lactosefree	39389	27251	69.184290
96	packaged produce	17408	12021	69.054458
33	cream	19786	13625	68.861821
133	yogurt	90751	62464	68.830096
11	bread	36381	24540	67.452791
110	refrigerated	35893	23854	66.458641
12	breakfast bakery	15357	9991	65.058280
43	energy sports drinks	6638	4256	64.115697
14	bulk dried fruits vegetables	1059	678	64.022663
117	soft drinks	22428	14299	63.755128
98	packaged vegetables fruits	109596	69872	63.754152
28	coffee	12823	8059	62.848007
128	trail mix snack mix	2238	1401	62.600536
104	poultry counter	8131	5084	62.526135
105	prepared meals	6144	3835	62.418620
23	cat food care	3835	2392	62.372881
132	white wines	1893	1179	62.282092
56	frozen breakfast	14346	8914	62.135787
49	fresh dips tapenades	22175	13639	61.506201
80	lunch meat	24470	15003	61.311810
66	granola	6410	3928	61.279251
95	packaged poultry	7467	4557	61.028526
126	tofu meat alternatives	8003	4872	60.877171
42	energy granola bars	28639	17181	59.991620
75	juice nectars	20715	12378	59.753802
103	popcorn jerky	10415	6201	59.539126
53	fresh vegetables	212611	126171	59.343590
4	baby food formula	23355	13847	59.289231
25	chips pretzels	45306	26615	58.744979
106	prepared soups salads	4384	2568	58.576642
64	fruit vegetable snacks	10931	6401	58.558229
93	packaged cheese	61502	35864	58.313551
61	frozen pizza	10124	5869	57.971158
17	butter	15735	9062	57.591357
13	breakfast bars pastries	4621	2653	57.411816
18	candy chocolate	18735	10731	57.277822
24	cereal	23754	13593	57.224046
38	dog food care	2178	1242	57.024793
32	crackers	28574	16257	56.894380
84	mint gum	1377	781	56.717502
19	canned fruit applesauce	5458	3090	56.614144
92	other creams cheeses	19091	10798	56.560683
59	frozen meals	24449	13622	55.715980
70	hot dogs bacon sausage	19037	10575	55.549719
127	tortillas flat bread	12082	6654	55.073663
123	spirits	1795	988	55.041783
31	cookies cakes	14745	8097	54.913530
9	beers coolers	3002	1646	54.830113
55	frozen breads doughs	2486	1353	54.424779
109	red wines	2135	1158	54.238876
94	packaged meat	2020	1094	54.158416
63	frozen vegan vegetarian	6321	3397	53.741497
62	frozen produce	32432	17425	53.727800
111	refrigerated pudding desserts	2423	1301	53.693768
60	frozen meat seafood	4408	2359	53.516334
82	meat counter	4472	2384	53.309481
16	buns rolls	6949	3658	52.640668
99	paper goods	15422	8106	52.561276
125	tea	15733	8268	52.551961
54	frozen appetizers sides	12178	6386	52.438824
113	seafood counter	1843	966	52.414542
35	diapers wipes	1566	819	52.298851
88	nuts seeds dried fruit	19026	9935	52.218017
2	baby accessories	504	260	51.587302
51	fresh herbs	23342	12006	51.435181
15	bulk grains rice dried goods	1074	552	51.396648
97	packaged seafood	1301	666	51.191391
108	protein meal replacements	2257	1149	50.908285
5	bakery desserts	2214	1126	50.858175
21	canned meals beans	16818	8513	50.618385
52	fresh pasta	2340	1183	50.555556
69	hot cereal pancake mixes	9820	4872	49.613035
74	instant foods	12651	6194	48.960556
124	spreads	18149	8845	48.735468
71	ice cream ice	31323	15185	48.478754
120	specialty cheeses	5102	2473	48.471188
121	specialty wines champagnes	614	293	47.719870
100	pasta sauce	13771	6536	47.462058
22	canned meat seafood	4212	1982	47.056030
107	preserved dips spreads	6866	3218	46.868628
40	dry pasta	16414	7501	45.698794
102	plates bowls cups flatware	2671	1188	44.477724
101	pickled goods olives	6925	3075	44.404332
36	digestion	1727	764	44.238564
58	frozen juice	279	121	43.369176
57	frozen dessert	1190	504	42.352941
118	soup broth bouillon	21540	9120	42.339833
20	canned jarred vegetables	18025	7559	41.936200
79	laundry	5904	2420	40.989160
39	doughs gelatins bake mixes	6693	2733	40.833707
91	other	2240	905	40.401786
27	cocoa drink mixes	1332	536	40.240240
78	latino foods	4652	1851	39.789338
77	kosher foods	697	275	39.454806
37	dish detergents	5867	2301	39.219363
85	missing	4749	1860	39.166140
65	grains rice dried goods	8878	3468	39.062852
73	indian foods	963	352	36.552440
68	honeys syrups nectars	4156	1471	35.394610
89	oils vinegars	15213	5359	35.226451
129	trash bags liners	2020	697	34.504950
87	muscles joints pain relief	1256	433	34.474522
1	asian foods	10426	3561	34.154997
112	salad dressing toppings	6009	2041	33.965718
10	body lotions soap	2507	833	33.226964
116	soap	3918	1301	33.205717
130	vitamins supplements	2912	939	32.245879
45	facial care	843	268	31.791222
90	oral hygiene	4018	1273	31.682429
30	condiments	13760	4266	31.002907
6	baking ingredients	20137	6145	30.515966
46	feminine care	1296	395	30.478395
0	air fresheners candles	1258	365	29.014308
26	cleaning products	7429	2144	28.859873
81	marinades meat preparation	3836	1066	27.789364
3	baby bath body care	515	143	27.766990
115	skin care	654	179	27.370031
29	cold flu allergy	1589	430	27.061045
72	ice cream toppings	706	184	26.062323
114	shave needs	646	164	25.386997
67	hair care	1909	481	25.196438
48	food storage	4144	1044	25.193050
86	more household	1170	293	25.042735
34	deodorants	924	231	25.000000
76	kitchen supplies	561	120	21.390374
8	beauty	387	81	20.930233
47	first aid	693	145	20.923521
44	eye ear care	598	125	20.903010
7	baking supplies decor	1451	249	17.160579
122	spices seasonings	13067	1985	15.190939

#filter only the 30 most reordered
prod_reord_top30 = prod_reord[0:30]
prod_reord_top30

	product_name	ordered_sum	reordered_sum	reorder_probability
83	milk	55150	43162	78.262919
131	water seltzer sparkling water	52564	38467	73.181265
50	fresh fruits	226039	162355	71.826101
41	eggs	27986	19798	70.742514
119	soy lactosefree	39389	27251	69.184290
96	packaged produce	17408	12021	69.054458
33	cream	19786	13625	68.861821
133	yogurt	90751	62464	68.830096
11	bread	36381	24540	67.452791
110	refrigerated	35893	23854	66.458641
12	breakfast bakery	15357	9991	65.058280
43	energy sports drinks	6638	4256	64.115697
14	bulk dried fruits vegetables	1059	678	64.022663
117	soft drinks	22428	14299	63.755128
98	packaged vegetables fruits	109596	69872	63.754152
28	coffee	12823	8059	62.848007
128	trail mix snack mix	2238	1401	62.600536
104	poultry counter	8131	5084	62.526135
105	prepared meals	6144	3835	62.418620
23	cat food care	3835	2392	62.372881
132	white wines	1893	1179	62.282092
56	frozen breakfast	14346	8914	62.135787
49	fresh dips tapenades	22175	13639	61.506201
80	lunch meat	24470	15003	61.311810
66	granola	6410	3928	61.279251
95	packaged poultry	7467	4557	61.028526
126	tofu meat alternatives	8003	4872	60.877171
42	energy granola bars	28639	17181	59.991620
75	juice nectars	20715	12378	59.753802
103	popcorn jerky	10415	6201	59.539126

#Plotly Visualization
#Define the  data to plot
data_bar = (dict(type='bar',
                     y = prod_reord_top30['reorder_probability'],
                     x = prod_reord_top30['product_name'],
                     marker_color='lightseagreen',
                     showlegend=False
                    )
               )
#Define layout
layout_bar = dict(title=dict(
                        text='Products most reordered'
                        ),
                  yaxis=dict(title='% Reorder Probability'),
                  title_x=0.5,
                  
                 )
#Create the figure
fig_bar = go.Figure(data=data_bar, layout=layout_bar)

fig_bar.show()

Behaviors by product

#Create a new dataframe to merge products information  and orders information(dow, hour_of_day)
df_merge2 = pd.merge(df_merge, orders, how='left', on='order_id')
df_merge2

	order_id	product_id	add_to_cart_order	reordered	department_id	product_name	department	user_id	order_number	order_dow	order_hour_of_day	days_since_prior_order
0	10	24	1	1	4	fresh fruits	produce	135442	4	6	8	8.0
1	10	83	2	1	4	fresh vegetables	produce	135442	4	6	8	8.0
2	10	16	3	0	4	fresh herbs	produce	135442	4	6	8	8.0
3	10	24	4	1	4	fresh fruits	produce	135442	4	6	8	8.0
4	10	83	5	1	4	fresh vegetables	produce	135442	4	6	8	8.0
...	...	...	...	...	...	...	...	...	...	...	...	...
2019496	3420578	66	17	0	6	asian foods	international	6586	6	5	21	5.0
2019497	3420578	16	18	1	4	fresh herbs	produce	6586	6	5	21	5.0
2019498	3420693	37	1	0	1	ice cream ice	frozen	68287	15	6	15	6.0
2019499	3420693	37	2	0	1	ice cream ice	frozen	68287	15	6	15	6.0
2019500	3420693	37	3	0	1	ice cream ice	frozen	68287	15	6	15	6.0

2019501 rows × 12 columns

#Create a function to return the number of orders by day of week or per hour of the day to be use in the app
def frequent_time_prod(option, product):
    df = df_merge2[df_merge2['product_name']==product]
    if option == "Day of week":
        freq = df['order_dow'].value_counts()
    elif option == 'Hour of the day':
        freq = df['order_hour_of_day'].value_counts()
    return freq

#Create a function with a bar plotly vizualization with the option by user choose 'day of week' or 'hour of the day'
#Also chose the product
def update_barplot_prod(option, product):
    data_bar = (dict(type='bar',
                     x=frequent_time_prod(option, product).index,
                     y=frequent_time_prod(option, product).values,
                     marker_color=' cornflowerblue',
                     showlegend=False))  
    layout_bar = dict(title=dict(
                        text=f'Frequency by {option} - {product}'),
                  xaxis=dict(title=f'{option}'),
                  yaxis=dict(title='Itens sold'),
                  title_x=0.5)
    fig_bar_prod = go.Figure(data=data_bar, layout=layout_bar)
    return fig_bar_prod

#test the function. Set option = hour of the day and Fresh fruits
update_barplot_prod("Hour of the day",'fresh fruits')

Apriori Algorithm and Association rules

Pivot Table

# Pivot the data - lines as orders and products as columns
pt = pd.pivot_table(df1, index='order_id', columns='product_name', 
                    aggfunc=lambda x: 1 if len(x)>0 else 0).fillna(0)
# Show dataframe
pt

product_name	air fresheners candles	asian foods	baby accessories	baby bath body care	baby food formula	bakery desserts	baking ingredients	baking supplies decor	beauty	beers coolers	body lotions soap	bread	breakfast bakery	breakfast bars pastries	bulk dried fruits vegetables	bulk grains rice dried goods	buns rolls	butter	candy chocolate	canned fruit applesauce	canned jarred vegetables	canned meals beans	canned meat seafood	cat food care	cereal	chips pretzels	cleaning products	cocoa drink mixes	coffee	cold flu allergy	condiments	cookies cakes	crackers	cream	deodorants	diapers wipes	digestion	dish detergents	dog food care	doughs gelatins bake mixes	dry pasta	eggs	energy granola bars	energy sports drinks	eye ear care	facial care	feminine care	first aid	food storage	fresh dips tapenades	fresh fruits	fresh herbs	fresh pasta	fresh vegetables	frozen appetizers sides	frozen breads doughs	frozen breakfast	frozen dessert	frozen juice	frozen meals	frozen meat seafood	frozen pizza	frozen produce	frozen vegan vegetarian	fruit vegetable snacks	grains rice dried goods	granola	hair care	honeys syrups nectars	hot cereal pancake mixes	hot dogs bacon sausage	ice cream ice	ice cream toppings	indian foods	instant foods	juice nectars	kitchen supplies	kosher foods	latino foods	laundry	lunch meat	marinades meat preparation	meat counter	milk	mint gum	missing	more household	muscles joints pain relief	nuts seeds dried fruit	oils vinegars	oral hygiene	other	other creams cheeses	packaged cheese	packaged meat	packaged poultry	packaged produce	packaged seafood	packaged vegetables fruits	paper goods	pasta sauce	pickled goods olives	plates bowls cups flatware	popcorn jerky	poultry counter	prepared meals	prepared soups salads	preserved dips spreads	protein meal replacements	red wines	refrigerated	refrigerated pudding desserts	salad dressing toppings	seafood counter	shave needs	skin care	soap	soft drinks	soup broth bouillon	soy lactosefree	specialty cheeses	specialty wines champagnes	spices seasonings	spirits	spreads	tea	tofu meat alternatives	tortillas flat bread	trail mix snack mix	trash bags liners	vitamins supplements	water seltzer sparkling water	white wines	yogurt
order_id
10	0.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	1.0	0.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
11	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
28	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0
38	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
56	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...
3420991	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	1.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
3421019	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
3421027	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	1.0	0.0	1.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0
3421074	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
3421080	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0

200000 rows × 134 columns

Frequent Items

# Compute frequent items using the Apriori algorithm
frequent_itemsets = apriori(pt, min_support=0.03, use_colnames=True)

# Show dataframe
frequent_itemsets

	support	itemsets
0	0.043330	(asian foods)
1	0.045355	(baby food formula)
2	0.076635	(baking ingredients)
3	0.163865	(bread)
4	0.067765	(breakfast bakery)
5	0.032100	(buns rolls)
6	0.074330	(butter)
7	0.069305	(candy chocolate)
8	0.071890	(canned jarred vegetables)
9	0.069705	(canned meals beans)
10	0.092560	(cereal)
11	0.169435	(chips pretzels)
12	0.055650	(coffee)
13	0.059465	(condiments)
14	0.059725	(cookies cakes)
15	0.114970	(crackers)
16	0.091605	(cream)
17	0.070055	(dry pasta)
18	0.136490	(eggs)
19	0.086545	(energy granola bars)
20	0.098205	(fresh dips tapenades)
21	0.555995	(fresh fruits)
22	0.093005	(fresh herbs)
23	0.444360	(fresh vegetables)
24	0.051875	(frozen appetizers sides)
25	0.061165	(frozen breakfast)
26	0.074330	(frozen meals)
27	0.043065	(frozen pizza)
28	0.122580	(frozen produce)
29	0.046085	(fruit vegetable snacks)
30	0.040185	(grains rice dried goods)
31	0.045025	(hot cereal pancake mixes)
32	0.084190	(hot dogs bacon sausage)
33	0.110510	(ice cream ice)
34	0.051995	(instant foods)
35	0.089395	(juice nectars)
36	0.103890	(lunch meat)
37	0.243325	(milk)
38	0.080225	(nuts seeds dried fruit)
39	0.067350	(oils vinegars)
40	0.086485	(other creams cheeses)
41	0.230995	(packaged cheese)
42	0.036210	(packaged poultry)
43	0.062270	(packaged produce)
44	0.365415	(packaged vegetables fruits)
45	0.063575	(paper goods)
46	0.062660	(pasta sauce)
47	0.031630	(pickled goods olives)
48	0.046410	(popcorn jerky)
49	0.038980	(poultry counter)
50	0.032205	(preserved dips spreads)
51	0.134040	(refrigerated)
52	0.087310	(soft drinks)
53	0.083365	(soup broth bouillon)
54	0.168355	(soy lactosefree)
55	0.052165	(spices seasonings)
56	0.078185	(spreads)
57	0.057010	(tea)
58	0.032860	(tofu meat alternatives)
59	0.056455	(tortillas flat bread)
60	0.193005	(water seltzer sparkling water)
61	0.263675	(yogurt)
62	0.033810	(baby food formula, fresh fruits)
63	0.047305	(baking ingredients, fresh fruits)
64	0.043790	(baking ingredients, fresh vegetables)
65	0.032645	(baking ingredients, packaged vegetables fruits)
66	0.040185	(bread, chips pretzels)
67	0.036510	(bread, eggs)
68	0.112410	(bread, fresh fruits)
69	0.091590	(bread, fresh vegetables)
70	0.033565	(bread, lunch meat)
71	0.059705	(milk, bread)
72	0.059690	(bread, packaged cheese)
73	0.077055	(bread, packaged vegetables fruits)
74	0.035565	(bread, soy lactosefree)
75	0.033540	(bread, water seltzer sparkling water)
76	0.061840	(bread, yogurt)
77	0.045680	(breakfast bakery, fresh fruits)
78	0.033220	(breakfast bakery, fresh vegetables)
79	0.048920	(butter, fresh fruits)
80	0.044580	(butter, fresh vegetables)
81	0.033730	(butter, packaged vegetables fruits)
82	0.039820	(fresh fruits, candy chocolate)
83	0.048880	(fresh fruits, canned jarred vegetables)
84	0.055055	(canned jarred vegetables, fresh vegetables)
85	0.037835	(packaged vegetables fruits, canned jarred veg...
86	0.049890	(canned meals beans, fresh fruits)
87	0.050435	(canned meals beans, fresh vegetables)
88	0.037670	(packaged vegetables fruits, canned meals beans)
89	0.059620	(cereal, fresh fruits)
90	0.043325	(cereal, fresh vegetables)
91	0.035920	(milk, cereal)
92	0.030985	(packaged cheese, cereal)
93	0.039750	(packaged vegetables fruits, cereal)
94	0.036675	(cereal, yogurt)
95	0.035630	(chips pretzels, crackers)
96	0.035200	(chips pretzels, fresh dips tapenades)
97	0.106300	(chips pretzels, fresh fruits)
98	0.082245	(chips pretzels, fresh vegetables)
99	0.048915	(milk, chips pretzels)
100	0.056405	(packaged cheese, chips pretzels)
101	0.073545	(packaged vegetables fruits, chips pretzels)
102	0.032145	(chips pretzels, refrigerated)
103	0.035170	(soy lactosefree, chips pretzels)
104	0.041055	(water seltzer sparkling water, chips pretzels)
105	0.056980	(chips pretzels, yogurt)
106	0.031855	(fresh fruits, coffee)
107	0.036830	(fresh fruits, condiments)
108	0.036290	(condiments, fresh vegetables)
109	0.034610	(cookies cakes, fresh fruits)
110	0.075480	(fresh fruits, crackers)
111	0.057335	(crackers, fresh vegetables)
112	0.036175	(milk, crackers)
113	0.043875	(packaged cheese, crackers)
114	0.052650	(packaged vegetables fruits, crackers)
115	0.043040	(crackers, yogurt)
116	0.057010	(fresh fruits, cream)
117	0.044830	(cream, fresh vegetables)
118	0.033915	(milk, cream)
119	0.037260	(packaged vegetables fruits, cream)
120	0.031030	(cream, yogurt)
121	0.048095	(dry pasta, fresh fruits)
122	0.047235	(dry pasta, fresh vegetables)
123	0.036440	(packaged vegetables fruits, dry pasta)
124	0.095325	(eggs, fresh fruits)
125	0.084310	(eggs, fresh vegetables)
126	0.047795	(milk, eggs)
127	0.045435	(eggs, packaged cheese)
128	0.068650	(eggs, packaged vegetables fruits)
129	0.030170	(soy lactosefree, eggs)
130	0.049905	(eggs, yogurt)
131	0.059450	(fresh fruits, energy granola bars)
132	0.040640	(energy granola bars, fresh vegetables)
133	0.039500	(packaged vegetables fruits, energy granola bars)
134	0.034610	(energy granola bars, yogurt)
135	0.069040	(fresh fruits, fresh dips tapenades)
136	0.057955	(fresh dips tapenades, fresh vegetables)
137	0.034370	(packaged cheese, fresh dips tapenades)
138	0.053785	(packaged vegetables fruits, fresh dips tapena...
139	0.037500	(fresh dips tapenades, yogurt)
140	0.070135	(fresh fruits, fresh herbs)
141	0.317560	(fresh fruits, fresh vegetables)
142	0.033035	(frozen appetizers sides, fresh fruits)
143	0.042035	(fresh fruits, frozen breakfast)
144	0.044090	(frozen meals, fresh fruits)
145	0.089235	(frozen produce, fresh fruits)
146	0.031460	(fruit vegetable snacks, fresh fruits)
147	0.031740	(hot cereal pancake mixes, fresh fruits)
148	0.054425	(hot dogs bacon sausage, fresh fruits)
149	0.064485	(fresh fruits, ice cream ice)
150	0.033840	(fresh fruits, instant foods)
151	0.055600	(juice nectars, fresh fruits)
152	0.072290	(lunch meat, fresh fruits)
153	0.164310	(milk, fresh fruits)
154	0.054750	(nuts seeds dried fruit, fresh fruits)
155	0.042885	(oils vinegars, fresh fruits)
156	0.056630	(other creams cheeses, fresh fruits)
157	0.155900	(packaged cheese, fresh fruits)
158	0.039945	(packaged produce, fresh fruits)
159	0.269870	(packaged vegetables fruits, fresh fruits)
160	0.032090	(paper goods, fresh fruits)
161	0.042840	(fresh fruits, pasta sauce)
162	0.086430	(fresh fruits, refrigerated)
163	0.039585	(soft drinks, fresh fruits)
164	0.053880	(soup broth bouillon, fresh fruits)
165	0.117480	(soy lactosefree, fresh fruits)
166	0.033220	(spices seasonings, fresh fruits)
167	0.053560	(fresh fruits, spreads)
168	0.033720	(fresh fruits, tea)
169	0.039205	(fresh fruits, tortillas flat bread)
170	0.111045	(water seltzer sparkling water, fresh fruits)
171	0.188225	(fresh fruits, yogurt)
172	0.078655	(fresh herbs, fresh vegetables)
173	0.030290	(packaged cheese, fresh herbs)
174	0.052535	(packaged vegetables fruits, fresh herbs)
175	0.032285	(frozen breakfast, fresh vegetables)
176	0.034625	(frozen meals, fresh vegetables)
177	0.077750	(frozen produce, fresh vegetables)
178	0.049460	(hot dogs bacon sausage, fresh vegetables)
179	0.051995	(ice cream ice, fresh vegetables)
180	0.042775	(juice nectars, fresh vegetables)
181	0.060095	(lunch meat, fresh vegetables)
182	0.124715	(milk, fresh vegetables)
183	0.041775	(nuts seeds dried fruit, fresh vegetables)
184	0.042610	(oils vinegars, fresh vegetables)
185	0.052105	(other creams cheeses, fresh vegetables)
186	0.135850	(packaged cheese, fresh vegetables)
187	0.234555	(packaged vegetables fruits, fresh vegetables)
188	0.041005	(pasta sauce, fresh vegetables)
189	0.065825	(refrigerated, fresh vegetables)
190	0.055380	(soup broth bouillon, fresh vegetables)
191	0.094120	(soy lactosefree, fresh vegetables)
192	0.036660	(spices seasonings, fresh vegetables)
193	0.040795	(spreads, fresh vegetables)
194	0.036525	(tortillas flat bread, fresh vegetables)
195	0.083355	(water seltzer sparkling water, fresh vegetables)
196	0.144660	(yogurt, fresh vegetables)
197	0.031925	(frozen meals, packaged vegetables fruits)
198	0.035660	(milk, frozen produce)
199	0.038850	(frozen produce, packaged cheese)
200	0.066985	(frozen produce, packaged vegetables fruits)
201	0.032885	(soy lactosefree, frozen produce)
202	0.045295	(frozen produce, yogurt)
203	0.031280	(hot dogs bacon sausage, packaged cheese)
204	0.040315	(hot dogs bacon sausage, packaged vegetables f...
205	0.030960	(milk, ice cream ice)
206	0.033045	(packaged cheese, ice cream ice)
207	0.043735	(packaged vegetables fruits, ice cream ice)
208	0.036035	(ice cream ice, yogurt)
209	0.037425	(juice nectars, packaged vegetables fruits)
210	0.030060	(juice nectars, yogurt)
211	0.035760	(milk, lunch meat)
212	0.045205	(lunch meat, packaged cheese)
213	0.053225	(lunch meat, packaged vegetables fruits)
214	0.039605	(lunch meat, yogurt)
215	0.030955	(milk, other creams cheeses)
216	0.078170	(milk, packaged cheese)
217	0.107425	(milk, packaged vegetables fruits)
218	0.040280	(milk, refrigerated)
219	0.041220	(milk, soy lactosefree)
220	0.046610	(milk, water seltzer sparkling water)
221	0.095705	(milk, yogurt)
222	0.038315	(nuts seeds dried fruit, packaged vegetables f...
223	0.031680	(packaged vegetables fruits, oils vinegars)
224	0.036400	(packaged cheese, other creams cheeses)
225	0.040265	(packaged vegetables fruits, other creams chee...
226	0.032155	(other creams cheeses, yogurt)
227	0.114610	(packaged cheese, packaged vegetables fruits)
228	0.037880	(packaged cheese, refrigerated)
229	0.046265	(soy lactosefree, packaged cheese)
230	0.048255	(water seltzer sparkling water, packaged cheese)
231	0.088520	(packaged cheese, yogurt)
232	0.032595	(packaged vegetables fruits, pasta sauce)
233	0.058705	(packaged vegetables fruits, refrigerated)
234	0.041045	(packaged vegetables fruits, soup broth bouillon)
235	0.081385	(soy lactosefree, packaged vegetables fruits)
236	0.036465	(packaged vegetables fruits, spreads)
237	0.073715	(water seltzer sparkling water, packaged veget...
238	0.127910	(packaged vegetables fruits, yogurt)
239	0.030175	(soy lactosefree, refrigerated)
240	0.032250	(water seltzer sparkling water, refrigerated)
241	0.047175	(refrigerated, yogurt)
242	0.037075	(water seltzer sparkling water, soy lactosefree)
243	0.058195	(soy lactosefree, yogurt)
244	0.056185	(water seltzer sparkling water, yogurt)
245	0.032470	(baking ingredients, fresh fruits, fresh veget...
246	0.072365	(bread, fresh fruits, fresh vegetables)
247	0.045210	(milk, bread, fresh fruits)
248	0.044665	(bread, packaged cheese, fresh fruits)
249	0.062430	(bread, packaged vegetables fruits, fresh fruits)
250	0.048950	(bread, fresh fruits, yogurt)
251	0.035350	(milk, bread, fresh vegetables)
252	0.037740	(bread, packaged cheese, fresh vegetables)
253	0.053835	(bread, packaged vegetables fruits, fresh vege...
254	0.038560	(bread, yogurt, fresh vegetables)
255	0.031295	(milk, bread, packaged vegetables fruits)
256	0.033280	(bread, packaged cheese, packaged vegetables f...
257	0.034755	(bread, packaged vegetables fruits, yogurt)
258	0.033965	(butter, fresh fruits, fresh vegetables)
259	0.040955	(fresh fruits, canned jarred vegetables, fresh...
260	0.031925	(packaged vegetables fruits, canned jarred veg...
261	0.039670	(canned meals beans, fresh fruits, fresh veget...
262	0.030560	(canned meals beans, packaged vegetables fruit...
263	0.030555	(packaged vegetables fruits, canned meals bean...
264	0.034865	(cereal, fresh fruits, fresh vegetables)
265	0.031780	(packaged vegetables fruits, cereal, fresh fru...
266	0.063685	(chips pretzels, fresh fruits, fresh vegetables)
267	0.036000	(milk, chips pretzels, fresh fruits)
268	0.040565	(packaged cheese, chips pretzels, fresh fruits)
269	0.057595	(packaged vegetables fruits, chips pretzels, f...
270	0.044025	(chips pretzels, fresh fruits, yogurt)
271	0.033535	(packaged cheese, chips pretzels, fresh vegeta...
272	0.048105	(packaged vegetables fruits, chips pretzels, f...
273	0.032885	(yogurt, chips pretzels, fresh vegetables)
274	0.030665	(packaged cheese, packaged vegetables fruits, ...
275	0.031465	(packaged vegetables fruits, chips pretzels, y...
276	0.045875	(fresh fruits, crackers, fresh vegetables)
277	0.032260	(packaged cheese, fresh fruits, crackers)
278	0.042385	(packaged vegetables fruits, fresh fruits, cra...
279	0.033385	(fresh fruits, crackers, yogurt)
280	0.035225	(packaged vegetables fruits, crackers, fresh v...
281	0.033990	(fresh fruits, cream, fresh vegetables)
282	0.036115	(dry pasta, fresh fruits, fresh vegetables)
283	0.066145	(eggs, fresh fruits, fresh vegetables)
284	0.036475	(milk, eggs, fresh fruits)
285	0.034460	(eggs, fresh fruits, packaged cheese)
286	0.055045	(eggs, packaged vegetables fruits, fresh fruits)
287	0.040000	(eggs, fresh fruits, yogurt)
288	0.030660	(milk, eggs, fresh vegetables)
289	0.031160	(eggs, fresh vegetables, packaged cheese)
290	0.050675	(eggs, packaged vegetables fruits, fresh veget...
291	0.033470	(eggs, yogurt, fresh vegetables)
292	0.033845	(fresh fruits, energy granola bars, fresh vege...
293	0.032945	(packaged vegetables fruits, fresh fruits, ene...
294	0.046625	(fresh fruits, fresh dips tapenades, fresh veg...
295	0.043245	(packaged vegetables fruits, fresh fruits, fre...
296	0.030350	(fresh fruits, fresh dips tapenades, yogurt)
297	0.038095	(packaged vegetables fruits, fresh dips tapena...
298	0.061815	(fresh fruits, fresh herbs, fresh vegetables)
299	0.043490	(packaged vegetables fruits, fresh fruits, fre...
300	0.062170	(frozen produce, fresh fruits, fresh vegetables)
301	0.037215	(hot dogs bacon sausage, fresh fruits, fresh v...
302	0.038700	(fresh fruits, ice cream ice, fresh vegetables)
303	0.033055	(juice nectars, fresh fruits, fresh vegetables)
304	0.047870	(lunch meat, fresh fruits, fresh vegetables)
305	0.099590	(milk, fresh fruits, fresh vegetables)
306	0.034350	(nuts seeds dried fruit, fresh fruits, fresh v...
307	0.031600	(oils vinegars, fresh fruits, fresh vegetables)
308	0.039015	(other creams cheeses, fresh fruits, fresh veg...
309	0.104570	(packaged cheese, fresh fruits, fresh vegetables)
310	0.186580	(packaged vegetables fruits, fresh fruits, fre...
311	0.031430	(fresh fruits, pasta sauce, fresh vegetables)
312	0.051445	(refrigerated, fresh fruits, fresh vegetables)
313	0.040940	(soup broth bouillon, fresh fruits, fresh vege...
314	0.075620	(soy lactosefree, fresh fruits, fresh vegetables)
315	0.032885	(fresh fruits, fresh vegetables, spreads)
316	0.063235	(water seltzer sparkling water, fresh fruits, ...
317	0.118420	(yogurt, fresh fruits, fresh vegetables)
318	0.030715	(frozen produce, packaged cheese, fresh fruits)
319	0.054415	(frozen produce, packaged vegetables fruits, f...
320	0.036900	(frozen produce, fresh fruits, yogurt)
321	0.031455	(hot dogs bacon sausage, packaged vegetables f...
322	0.033125	(packaged vegetables fruits, fresh fruits, ice...
323	0.033515	(lunch meat, fresh fruits, packaged cheese)
324	0.043000	(lunch meat, packaged vegetables fruits, fresh...
325	0.032140	(lunch meat, fresh fruits, yogurt)
326	0.059885	(milk, packaged cheese, fresh fruits)
327	0.087450	(milk, packaged vegetables fruits, fresh fruits)
328	0.031440	(milk, soy lactosefree, fresh fruits)
329	0.033700	(milk, water seltzer sparkling water, fresh fr...
330	0.074860	(milk, fresh fruits, yogurt)
331	0.031575	(nuts seeds dried fruit, packaged vegetables f...
332	0.031435	(packaged vegetables fruits, other creams chee...
333	0.090715	(packaged cheese, packaged vegetables fruits, ...
334	0.036390	(soy lactosefree, packaged cheese, fresh fruits)
335	0.034565	(water seltzer sparkling water, packaged chees...
336	0.070020	(packaged cheese, fresh fruits, yogurt)
337	0.046595	(packaged vegetables fruits, fresh fruits, ref...
338	0.031405	(packaged vegetables fruits, soup broth bouill...
339	0.066960	(soy lactosefree, packaged vegetables fruits, ...
340	0.056550	(water seltzer sparkling water, packaged veget...
341	0.105790	(packaged vegetables fruits, fresh fruits, yog...
342	0.036030	(refrigerated, fresh fruits, yogurt)
343	0.046075	(soy lactosefree, fresh fruits, yogurt)
344	0.041895	(water seltzer sparkling water, fresh fruits, ...
345	0.046980	(packaged vegetables fruits, fresh herbs, fres...
346	0.048895	(frozen produce, packaged vegetables fruits, f...
347	0.031330	(frozen produce, yogurt, fresh vegetables)
348	0.037600	(lunch meat, packaged vegetables fruits, fresh...
349	0.049305	(milk, packaged cheese, fresh vegetables)
350	0.073075	(milk, packaged vegetables fruits, fresh veget...
351	0.056510	(milk, yogurt, fresh vegetables)
352	0.081970	(packaged cheese, packaged vegetables fruits, ...
353	0.030345	(soy lactosefree, packaged cheese, fresh veget...
354	0.057195	(packaged cheese, yogurt, fresh vegetables)
355	0.038470	(refrigerated, packaged vegetables fruits, fre...
356	0.032055	(packaged vegetables fruits, soup broth bouill...
357	0.057695	(soy lactosefree, packaged vegetables fruits, ...
358	0.047105	(water seltzer sparkling water, packaged veget...
359	0.087995	(packaged vegetables fruits, yogurt, fresh veg...
360	0.035635	(soy lactosefree, yogurt, fresh vegetables)
361	0.030395	(water seltzer sparkling water, yogurt, fresh ...
362	0.043830	(milk, packaged cheese, packaged vegetables fr...
363	0.038465	(milk, packaged cheese, yogurt)
364	0.051295	(milk, packaged vegetables fruits, yogurt)
365	0.051915	(packaged cheese, packaged vegetables fruits, ...
366	0.032535	(soy lactosefree, packaged vegetables fruits, ...
367	0.031275	(bread, packaged cheese, fresh fruits, fresh v...
368	0.045910	(bread, packaged vegetables fruits, fresh frui...
369	0.033370	(bread, yogurt, fresh fruits, fresh vegetables)
370	0.030265	(bread, packaged vegetables fruits, fresh frui...
371	0.040325	(packaged vegetables fruits, chips pretzels, f...
372	0.030350	(packaged vegetables fruits, fresh fruits, cra...
373	0.042555	(eggs, packaged vegetables fruits, fresh fruit...
374	0.032265	(packaged vegetables fruits, fresh fruits, fre...
375	0.039660	(packaged vegetables fruits, fresh fruits, fre...
376	0.041445	(frozen produce, packaged vegetables fruits, f...
377	0.031940	(lunch meat, packaged vegetables fruits, fresh...
378	0.041475	(milk, packaged cheese, fresh fruits, fresh ve...
379	0.062535	(milk, packaged vegetables fruits, fresh fruit...
380	0.048835	(milk, yogurt, fresh fruits, fresh vegetables)
381	0.068325	(packaged cheese, packaged vegetables fruits, ...
382	0.049105	(yogurt, packaged cheese, fresh fruits, fresh ...
383	0.032460	(packaged vegetables fruits, fresh fruits, fre...
384	0.049600	(soy lactosefree, packaged vegetables fruits, ...
385	0.038645	(water seltzer sparkling water, packaged veget...
386	0.076240	(yogurt, packaged vegetables fruits, fresh fru...
387	0.030910	(soy lactosefree, yogurt, fresh fruits, fresh ...
388	0.037380	(milk, packaged cheese, packaged vegetables fr...
389	0.032280	(milk, packaged cheese, fresh fruits, yogurt)
390	0.044575	(milk, packaged vegetables fruits, fresh fruit...
391	0.044825	(packaged cheese, packaged vegetables fruits, ...
392	0.032215	(milk, packaged cheese, packaged vegetables fr...
393	0.036455	(milk, packaged vegetables fruits, yogurt, fre...
394	0.038635	(packaged cheese, packaged vegetables fruits, ...
395	0.032845	(milk, packaged vegetables fruits, fresh fruit...
396	0.034565	(packaged vegetables fruits, fresh fruits, fre...

# Create new support dataframe for two products only
frequent_itemsets_two = apriori(pt, min_support=0.03, use_colnames=True,  max_len = 2)

# Show dataframe
frequent_itemsets_two

	support	itemsets
0	0.043330	(asian foods)
1	0.045355	(baby food formula)
2	0.076635	(baking ingredients)
3	0.163865	(bread)
4	0.067765	(breakfast bakery)
5	0.032100	(buns rolls)
6	0.074330	(butter)
7	0.069305	(candy chocolate)
8	0.071890	(canned jarred vegetables)
9	0.069705	(canned meals beans)
10	0.092560	(cereal)
11	0.169435	(chips pretzels)
12	0.055650	(coffee)
13	0.059465	(condiments)
14	0.059725	(cookies cakes)
15	0.114970	(crackers)
16	0.091605	(cream)
17	0.070055	(dry pasta)
18	0.136490	(eggs)
19	0.086545	(energy granola bars)
20	0.098205	(fresh dips tapenades)
21	0.555995	(fresh fruits)
22	0.093005	(fresh herbs)
23	0.444360	(fresh vegetables)
24	0.051875	(frozen appetizers sides)
25	0.061165	(frozen breakfast)
26	0.074330	(frozen meals)
27	0.043065	(frozen pizza)
28	0.122580	(frozen produce)
29	0.046085	(fruit vegetable snacks)
30	0.040185	(grains rice dried goods)
31	0.045025	(hot cereal pancake mixes)
32	0.084190	(hot dogs bacon sausage)
33	0.110510	(ice cream ice)
34	0.051995	(instant foods)
35	0.089395	(juice nectars)
36	0.103890	(lunch meat)
37	0.243325	(milk)
38	0.080225	(nuts seeds dried fruit)
39	0.067350	(oils vinegars)
40	0.086485	(other creams cheeses)
41	0.230995	(packaged cheese)
42	0.036210	(packaged poultry)
43	0.062270	(packaged produce)
44	0.365415	(packaged vegetables fruits)
45	0.063575	(paper goods)
46	0.062660	(pasta sauce)
47	0.031630	(pickled goods olives)
48	0.046410	(popcorn jerky)
49	0.038980	(poultry counter)
50	0.032205	(preserved dips spreads)
51	0.134040	(refrigerated)
52	0.087310	(soft drinks)
53	0.083365	(soup broth bouillon)
54	0.168355	(soy lactosefree)
55	0.052165	(spices seasonings)
56	0.078185	(spreads)
57	0.057010	(tea)
58	0.032860	(tofu meat alternatives)
59	0.056455	(tortillas flat bread)
60	0.193005	(water seltzer sparkling water)
61	0.263675	(yogurt)
62	0.033810	(baby food formula, fresh fruits)
63	0.047305	(baking ingredients, fresh fruits)
64	0.043790	(baking ingredients, fresh vegetables)
65	0.032645	(baking ingredients, packaged vegetables fruits)
66	0.040185	(bread, chips pretzels)
67	0.036510	(bread, eggs)
68	0.112410	(bread, fresh fruits)
69	0.091590	(bread, fresh vegetables)
70	0.033565	(bread, lunch meat)
71	0.059705	(milk, bread)
72	0.059690	(bread, packaged cheese)
73	0.077055	(bread, packaged vegetables fruits)
74	0.035565	(bread, soy lactosefree)
75	0.033540	(bread, water seltzer sparkling water)
76	0.061840	(bread, yogurt)
77	0.045680	(breakfast bakery, fresh fruits)
78	0.033220	(breakfast bakery, fresh vegetables)
79	0.048920	(butter, fresh fruits)
80	0.044580	(butter, fresh vegetables)
81	0.033730	(butter, packaged vegetables fruits)
82	0.039820	(fresh fruits, candy chocolate)
83	0.048880	(fresh fruits, canned jarred vegetables)
84	0.055055	(canned jarred vegetables, fresh vegetables)
85	0.037835	(packaged vegetables fruits, canned jarred veg...
86	0.049890	(canned meals beans, fresh fruits)
87	0.050435	(canned meals beans, fresh vegetables)
88	0.037670	(packaged vegetables fruits, canned meals beans)
89	0.059620	(cereal, fresh fruits)
90	0.043325	(cereal, fresh vegetables)
91	0.035920	(milk, cereal)
92	0.030985	(packaged cheese, cereal)
93	0.039750	(packaged vegetables fruits, cereal)
94	0.036675	(cereal, yogurt)
95	0.035630	(chips pretzels, crackers)
96	0.035200	(chips pretzels, fresh dips tapenades)
97	0.106300	(chips pretzels, fresh fruits)
98	0.082245	(chips pretzels, fresh vegetables)
99	0.048915	(milk, chips pretzels)
100	0.056405	(packaged cheese, chips pretzels)
101	0.073545	(packaged vegetables fruits, chips pretzels)
102	0.032145	(chips pretzels, refrigerated)
103	0.035170	(soy lactosefree, chips pretzels)
104	0.041055	(water seltzer sparkling water, chips pretzels)
105	0.056980	(chips pretzels, yogurt)
106	0.031855	(fresh fruits, coffee)
107	0.036830	(fresh fruits, condiments)
108	0.036290	(condiments, fresh vegetables)
109	0.034610	(cookies cakes, fresh fruits)
110	0.075480	(fresh fruits, crackers)
111	0.057335	(crackers, fresh vegetables)
112	0.036175	(milk, crackers)
113	0.043875	(packaged cheese, crackers)
114	0.052650	(packaged vegetables fruits, crackers)
115	0.043040	(crackers, yogurt)
116	0.057010	(fresh fruits, cream)
117	0.044830	(cream, fresh vegetables)
118	0.033915	(milk, cream)
119	0.037260	(packaged vegetables fruits, cream)
120	0.031030	(cream, yogurt)
121	0.048095	(dry pasta, fresh fruits)
122	0.047235	(dry pasta, fresh vegetables)
123	0.036440	(packaged vegetables fruits, dry pasta)
124	0.095325	(eggs, fresh fruits)
125	0.084310	(eggs, fresh vegetables)
126	0.047795	(milk, eggs)
127	0.045435	(eggs, packaged cheese)
128	0.068650	(eggs, packaged vegetables fruits)
129	0.030170	(soy lactosefree, eggs)
130	0.049905	(eggs, yogurt)
131	0.059450	(fresh fruits, energy granola bars)
132	0.040640	(energy granola bars, fresh vegetables)
133	0.039500	(packaged vegetables fruits, energy granola bars)
134	0.034610	(energy granola bars, yogurt)
135	0.069040	(fresh fruits, fresh dips tapenades)
136	0.057955	(fresh dips tapenades, fresh vegetables)
137	0.034370	(packaged cheese, fresh dips tapenades)
138	0.053785	(packaged vegetables fruits, fresh dips tapena...
139	0.037500	(fresh dips tapenades, yogurt)
140	0.070135	(fresh fruits, fresh herbs)
141	0.317560	(fresh fruits, fresh vegetables)
142	0.033035	(frozen appetizers sides, fresh fruits)
143	0.042035	(fresh fruits, frozen breakfast)
144	0.044090	(frozen meals, fresh fruits)
145	0.089235	(frozen produce, fresh fruits)
146	0.031460	(fruit vegetable snacks, fresh fruits)
147	0.031740	(hot cereal pancake mixes, fresh fruits)
148	0.054425	(hot dogs bacon sausage, fresh fruits)
149	0.064485	(fresh fruits, ice cream ice)
150	0.033840	(fresh fruits, instant foods)
151	0.055600	(juice nectars, fresh fruits)
152	0.072290	(lunch meat, fresh fruits)
153	0.164310	(milk, fresh fruits)
154	0.054750	(nuts seeds dried fruit, fresh fruits)
155	0.042885	(oils vinegars, fresh fruits)
156	0.056630	(other creams cheeses, fresh fruits)
157	0.155900	(packaged cheese, fresh fruits)
158	0.039945	(packaged produce, fresh fruits)
159	0.269870	(packaged vegetables fruits, fresh fruits)
160	0.032090	(paper goods, fresh fruits)
161	0.042840	(fresh fruits, pasta sauce)
162	0.086430	(fresh fruits, refrigerated)
163	0.039585	(soft drinks, fresh fruits)
164	0.053880	(soup broth bouillon, fresh fruits)
165	0.117480	(soy lactosefree, fresh fruits)
166	0.033220	(spices seasonings, fresh fruits)
167	0.053560	(fresh fruits, spreads)
168	0.033720	(fresh fruits, tea)
169	0.039205	(fresh fruits, tortillas flat bread)
170	0.111045	(water seltzer sparkling water, fresh fruits)
171	0.188225	(fresh fruits, yogurt)
172	0.078655	(fresh herbs, fresh vegetables)
173	0.030290	(packaged cheese, fresh herbs)
174	0.052535	(packaged vegetables fruits, fresh herbs)
175	0.032285	(frozen breakfast, fresh vegetables)
176	0.034625	(frozen meals, fresh vegetables)
177	0.077750	(frozen produce, fresh vegetables)
178	0.049460	(hot dogs bacon sausage, fresh vegetables)
179	0.051995	(ice cream ice, fresh vegetables)
180	0.042775	(juice nectars, fresh vegetables)
181	0.060095	(lunch meat, fresh vegetables)
182	0.124715	(milk, fresh vegetables)
183	0.041775	(nuts seeds dried fruit, fresh vegetables)
184	0.042610	(oils vinegars, fresh vegetables)
185	0.052105	(other creams cheeses, fresh vegetables)
186	0.135850	(packaged cheese, fresh vegetables)
187	0.234555	(packaged vegetables fruits, fresh vegetables)
188	0.041005	(pasta sauce, fresh vegetables)
189	0.065825	(refrigerated, fresh vegetables)
190	0.055380	(soup broth bouillon, fresh vegetables)
191	0.094120	(soy lactosefree, fresh vegetables)
192	0.036660	(spices seasonings, fresh vegetables)
193	0.040795	(spreads, fresh vegetables)
194	0.036525	(tortillas flat bread, fresh vegetables)
195	0.083355	(water seltzer sparkling water, fresh vegetables)
196	0.144660	(yogurt, fresh vegetables)
197	0.031925	(frozen meals, packaged vegetables fruits)
198	0.035660	(milk, frozen produce)
199	0.038850	(frozen produce, packaged cheese)
200	0.066985	(frozen produce, packaged vegetables fruits)
201	0.032885	(soy lactosefree, frozen produce)
202	0.045295	(frozen produce, yogurt)
203	0.031280	(hot dogs bacon sausage, packaged cheese)
204	0.040315	(hot dogs bacon sausage, packaged vegetables f...
205	0.030960	(milk, ice cream ice)
206	0.033045	(packaged cheese, ice cream ice)
207	0.043735	(packaged vegetables fruits, ice cream ice)
208	0.036035	(ice cream ice, yogurt)
209	0.037425	(juice nectars, packaged vegetables fruits)
210	0.030060	(juice nectars, yogurt)
211	0.035760	(milk, lunch meat)
212	0.045205	(lunch meat, packaged cheese)
213	0.053225	(lunch meat, packaged vegetables fruits)
214	0.039605	(lunch meat, yogurt)
215	0.030955	(milk, other creams cheeses)
216	0.078170	(milk, packaged cheese)
217	0.107425	(milk, packaged vegetables fruits)
218	0.040280	(milk, refrigerated)
219	0.041220	(milk, soy lactosefree)
220	0.046610	(milk, water seltzer sparkling water)
221	0.095705	(milk, yogurt)
222	0.038315	(nuts seeds dried fruit, packaged vegetables f...
223	0.031680	(packaged vegetables fruits, oils vinegars)
224	0.036400	(packaged cheese, other creams cheeses)
225	0.040265	(packaged vegetables fruits, other creams chee...
226	0.032155	(other creams cheeses, yogurt)
227	0.114610	(packaged cheese, packaged vegetables fruits)
228	0.037880	(packaged cheese, refrigerated)
229	0.046265	(soy lactosefree, packaged cheese)
230	0.048255	(water seltzer sparkling water, packaged cheese)
231	0.088520	(packaged cheese, yogurt)
232	0.032595	(packaged vegetables fruits, pasta sauce)
233	0.058705	(packaged vegetables fruits, refrigerated)
234	0.041045	(packaged vegetables fruits, soup broth bouillon)
235	0.081385	(soy lactosefree, packaged vegetables fruits)
236	0.036465	(packaged vegetables fruits, spreads)
237	0.073715	(water seltzer sparkling water, packaged veget...
238	0.127910	(packaged vegetables fruits, yogurt)
239	0.030175	(soy lactosefree, refrigerated)
240	0.032250	(water seltzer sparkling water, refrigerated)
241	0.047175	(refrigerated, yogurt)
242	0.037075	(water seltzer sparkling water, soy lactosefree)
243	0.058195	(soy lactosefree, yogurt)
244	0.056185	(water seltzer sparkling water, yogurt)

Association Rules

# Generate the association rules - by support

# Compute all association rules for frequent_itemsets
rulessupport = association_rules(frequent_itemsets, metric="support", min_threshold=0.03)
# Show dataframe
rulessupport

	antecedents	consequents	antecedent support	consequent support	support	confidence	lift	leverage	conviction
0	(baby food formula)	(fresh fruits)	0.045355	0.555995	0.033810	0.745453	1.340754	0.008593	1.744292
1	(fresh fruits)	(baby food formula)	0.555995	0.045355	0.033810	0.060810	1.340754	0.008593	1.016456
2	(baking ingredients)	(fresh fruits)	0.076635	0.555995	0.047305	0.617277	1.110220	0.004696	1.160120
3	(fresh fruits)	(baking ingredients)	0.555995	0.076635	0.047305	0.085082	1.110220	0.004696	1.009232
4	(baking ingredients)	(fresh vegetables)	0.076635	0.444360	0.043790	0.571410	1.285917	0.009736	1.296437
...	...	...	...	...	...	...	...	...	...
1545	(packaged vegetables fruits)	(yogurt, fresh fruits, packaged cheese, fresh ...	0.365415	0.049105	0.034565	0.094591	1.926302	0.016621	1.050238
1546	(fresh fruits)	(packaged cheese, packaged vegetables fruits, ...	0.555995	0.038635	0.034565	0.062168	1.609106	0.013084	1.025093
1547	(fresh vegetables)	(packaged cheese, packaged vegetables fruits, ...	0.444360	0.044825	0.034565	0.077786	1.735327	0.014647	1.035741
1548	(yogurt)	(packaged cheese, packaged vegetables fruits, ...	0.263675	0.068325	0.034565	0.131089	1.918616	0.016549	1.072233
1549	(packaged cheese)	(yogurt, packaged vegetables fruits, fresh fru...	0.230995	0.076240	0.034565	0.149635	1.962687	0.016954	1.086310

1550 rows × 9 columns

# Generate the association rules - by confidence

# Compute all association rules for frequent_itemsets
rulesConfidence = association_rules(frequent_itemsets, metric="confidence", min_threshold=0.50)

# Sort values
rulesConfidence.sort_values(by='confidence', ascending=False, inplace=True)

# Show dataframe
rulesConfidence

	antecedents	consequents	antecedent support	consequent support	support	confidence	lift	leverage	conviction
321	(packaged vegetables fruits, fresh fruits, fre...	(fresh vegetables)	0.043490	0.444360	0.039660	0.911934	2.052241	0.020335	6.309343
395	(milk, packaged vegetables fruits, yogurt, fre...	(fresh fruits)	0.036455	0.555995	0.032845	0.900974	1.620471	0.012576	4.483713
401	(packaged cheese, packaged vegetables fruits, ...	(fresh fruits)	0.038635	0.555995	0.034565	0.894655	1.609106	0.013084	4.214775
257	(packaged vegetables fruits, fresh herbs)	(fresh vegetables)	0.052535	0.444360	0.046980	0.894261	2.012470	0.023636	5.254824
172	(fresh fruits, fresh herbs)	(fresh vegetables)	0.070135	0.444360	0.061815	0.881372	1.983463	0.030650	4.683872
300	(bread, packaged vegetables fruits, yogurt)	(fresh fruits)	0.034755	0.555995	0.030265	0.870810	1.566219	0.010941	3.436836
382	(milk, packaged vegetables fruits, yogurt)	(fresh fruits)	0.051295	0.555995	0.044575	0.868993	1.562951	0.016055	3.389172
375	(soy lactosefree, fresh vegetables, yogurt)	(fresh fruits)	0.035635	0.555995	0.030910	0.867406	1.560096	0.011097	3.348596
370	(packaged vegetables fruits, fresh vegetables,...	(fresh fruits)	0.087995	0.555995	0.076240	0.866413	1.558311	0.027315	3.323711
298	(bread, fresh vegetables, yogurt)	(fresh fruits)	0.038560	0.555995	0.033370	0.865405	1.556497	0.011931	3.298812
346	(milk, fresh vegetables, yogurt)	(fresh fruits)	0.056510	0.555995	0.048835	0.864183	1.554301	0.017416	3.269150
384	(packaged cheese, packaged vegetables fruits, ...	(fresh fruits)	0.051915	0.555995	0.044825	0.863431	1.552947	0.015961	3.251131
307	(packaged vegetables fruits, crackers, fresh v...	(fresh fruits)	0.035225	0.555995	0.030350	0.861604	1.549661	0.010765	3.208221
361	(soy lactosefree, packaged vegetables fruits, ...	(fresh fruits)	0.057695	0.555995	0.049600	0.859693	1.546225	0.017522	3.164530
354	(packaged cheese, fresh vegetables, yogurt)	(fresh fruits)	0.057195	0.555995	0.049105	0.858554	1.544176	0.017305	3.139044
341	(milk, packaged vegetables fruits, fresh veget...	(fresh fruits)	0.073075	0.555995	0.062535	0.855765	1.539159	0.021906	3.078336
377	(milk, packaged cheese, packaged vegetables fr...	(fresh fruits)	0.043830	0.555995	0.037380	0.852841	1.533900	0.013011	3.017169
293	(bread, packaged vegetables fruits, fresh vege...	(fresh fruits)	0.053835	0.555995	0.045910	0.852791	1.533810	0.015978	3.016153
333	(lunch meat, packaged vegetables fruits, fresh...	(fresh fruits)	0.037600	0.555995	0.031940	0.849468	1.527834	0.011035	2.949574
328	(frozen produce, packaged vegetables fruits, f...	(fresh fruits)	0.048895	0.555995	0.041445	0.847633	1.524533	0.014260	2.914044
317	(packaged vegetables fruits, fresh dips tapena...	(fresh fruits)	0.038095	0.555995	0.032265	0.846962	1.523326	0.011084	2.901264
65	(fresh herbs)	(fresh vegetables)	0.093005	0.444360	0.078655	0.845707	1.903203	0.037327	3.601205
322	(packaged vegetables fruits, fresh herbs, fres...	(fresh fruits)	0.046980	0.555995	0.039660	0.844189	1.518339	0.013539	2.849639
110	(packaged vegetables fruits, canned jarred veg...	(fresh vegetables)	0.037835	0.444360	0.031925	0.843795	1.898901	0.015113	3.557130
357	(refrigerated, packaged vegetables fruits, fre...	(fresh fruits)	0.038470	0.555995	0.032460	0.843774	1.517593	0.011071	2.842075
338	(milk, packaged cheese, fresh vegetables)	(fresh fruits)	0.049305	0.555995	0.041475	0.841193	1.512950	0.014062	2.795871
312	(eggs, packaged vegetables fruits, fresh veget...	(fresh fruits)	0.050675	0.555995	0.042555	0.839763	1.510379	0.014380	2.770930
380	(milk, packaged cheese, yogurt)	(fresh fruits)	0.038465	0.555995	0.032280	0.839204	1.509374	0.010894	2.761302
303	(packaged vegetables fruits, chips pretzels, f...	(fresh fruits)	0.048105	0.555995	0.040325	0.838270	1.507694	0.013579	2.745355
107	(fresh fruits, canned jarred vegetables)	(fresh vegetables)	0.048880	0.444360	0.040955	0.837868	1.885562	0.019235	3.427089
163	(packaged vegetables fruits, energy granola bars)	(fresh fruits)	0.039500	0.555995	0.032945	0.834051	1.500105	0.010983	2.675545
349	(packaged cheese, packaged vegetables fruits, ...	(fresh fruits)	0.081970	0.555995	0.068325	0.833537	1.499180	0.022750	2.667284
162	(energy granola bars, fresh vegetables)	(fresh fruits)	0.040640	0.555995	0.033845	0.832800	1.497856	0.011249	2.655535
290	(bread, packaged cheese, fresh vegetables)	(fresh fruits)	0.037740	0.555995	0.031275	0.828696	1.490474	0.010292	2.591918
175	(packaged vegetables fruits, fresh herbs)	(fresh fruits)	0.052535	0.555995	0.043490	0.827829	1.488915	0.014281	2.578862
252	(packaged vegetables fruits, yogurt)	(fresh fruits)	0.127910	0.555995	0.105790	0.827066	1.487542	0.034673	2.567481
235	(nuts seeds dried fruit, packaged vegetables f...	(fresh fruits)	0.038315	0.555995	0.031575	0.824090	1.482189	0.010272	2.524043
248	(soy lactosefree, packaged vegetables fruits)	(fresh fruits)	0.081385	0.555995	0.066960	0.822756	1.479790	0.021710	2.505050
191	(nuts seeds dried fruit, fresh vegetables)	(fresh fruits)	0.041775	0.555995	0.034350	0.822262	1.478902	0.011123	2.498089
366	(water seltzer sparkling water, packaged veget...	(fresh fruits)	0.047105	0.555995	0.038645	0.820401	1.475555	0.012455	2.472205
216	(fresh vegetables, yogurt)	(fresh fruits)	0.144660	0.555995	0.118420	0.818609	1.472332	0.037990	2.447781
220	(frozen produce, yogurt)	(fresh fruits)	0.045295	0.555995	0.036900	0.814659	1.465228	0.011716	2.395617
230	(milk, packaged vegetables fruits)	(fresh fruits)	0.107425	0.555995	0.087450	0.814056	1.464143	0.027722	2.387847
218	(frozen produce, packaged vegetables fruits)	(fresh fruits)	0.066985	0.555995	0.054415	0.812346	1.461067	0.017172	2.366084
228	(lunch meat, yogurt)	(fresh fruits)	0.039605	0.555995	0.032140	0.811514	1.459570	0.010120	2.355635
115	(packaged vegetables fruits, canned meals beans)	(fresh fruits)	0.037670	0.555995	0.030560	0.811256	1.459106	0.009616	2.352415
117	(packaged vegetables fruits, canned meals beans)	(fresh vegetables)	0.037670	0.444360	0.030555	0.811123	1.825373	0.013816	2.941807
94	(bread, packaged vegetables fruits)	(fresh fruits)	0.077055	0.555995	0.062430	0.810201	1.457208	0.019588	2.339337
169	(fresh dips tapenades, yogurt)	(fresh fruits)	0.037500	0.555995	0.030350	0.809333	1.455649	0.009500	2.328698
226	(lunch meat, packaged vegetables fruits)	(fresh fruits)	0.053225	0.555995	0.043000	0.807891	1.453054	0.013407	2.311214
212	(spreads, fresh vegetables)	(fresh fruits)	0.040795	0.555995	0.032885	0.806104	1.449840	0.010203	2.289909
139	(packaged vegetables fruits, crackers)	(fresh fruits)	0.052650	0.555995	0.042385	0.805033	1.447915	0.013112	2.277337
120	(cereal, fresh vegetables)	(fresh fruits)	0.043325	0.555995	0.034865	0.804732	1.447372	0.010777	2.273820
166	(fresh dips tapenades, fresh vegetables)	(fresh fruits)	0.057955	0.555995	0.046625	0.804503	1.446962	0.014402	2.271166
167	(packaged vegetables fruits, fresh dips tapena...	(fresh fruits)	0.053785	0.555995	0.043245	0.804035	1.446118	0.013341	2.265731
210	(soy lactosefree, fresh vegetables)	(fresh fruits)	0.094120	0.555995	0.075620	0.803442	1.445053	0.023290	2.258905
153	(eggs, packaged vegetables fruits)	(fresh fruits)	0.068650	0.555995	0.055045	0.801821	1.442137	0.016876	2.240422
155	(eggs, yogurt)	(fresh fruits)	0.049905	0.555995	0.040000	0.801523	1.441601	0.012253	2.237059
137	(crackers, fresh vegetables)	(fresh fruits)	0.057335	0.555995	0.045875	0.800122	1.439081	0.013997	2.221381
178	(frozen produce, fresh vegetables)	(fresh fruits)	0.077750	0.555995	0.062170	0.799614	1.438168	0.018941	2.215750
121	(packaged vegetables fruits, cereal)	(fresh fruits)	0.039750	0.555995	0.031780	0.799497	1.437957	0.009679	2.214454
189	(milk, fresh vegetables)	(fresh fruits)	0.124715	0.555995	0.099590	0.798541	1.436237	0.030249	2.203944
187	(lunch meat, fresh vegetables)	(fresh fruits)	0.060095	0.555995	0.047870	0.796572	1.432697	0.014457	2.182616
199	(packaged vegetables fruits, fresh vegetables)	(fresh fruits)	0.234555	0.555995	0.186580	0.795464	1.430703	0.056169	2.170789
112	(canned meals beans, fresh fruits)	(fresh vegetables)	0.049890	0.444360	0.039670	0.795149	1.789426	0.017501	2.712415
244	(packaged vegetables fruits, refrigerated)	(fresh fruits)	0.058705	0.555995	0.046595	0.793714	1.427557	0.013955	2.152379
255	(soy lactosefree, yogurt)	(fresh fruits)	0.058195	0.555995	0.046075	0.791735	1.423996	0.013719	2.131920
96	(bread, yogurt)	(fresh fruits)	0.061840	0.555995	0.048950	0.791559	1.423680	0.014567	2.130122
239	(packaged cheese, packaged vegetables fruits)	(fresh fruits)	0.114610	0.555995	0.090715	0.791510	1.423593	0.026992	2.129626
243	(packaged cheese, yogurt)	(fresh fruits)	0.088520	0.555995	0.070020	0.791008	1.422688	0.020803	2.124504
217	(frozen produce, packaged cheese)	(fresh fruits)	0.038850	0.555995	0.030715	0.790605	1.421964	0.009115	2.120417
91	(bread, fresh vegetables)	(fresh fruits)	0.091590	0.555995	0.072365	0.790097	1.421051	0.021441	2.115288
113	(canned meals beans, fresh vegetables)	(fresh fruits)	0.050435	0.555995	0.039670	0.786557	1.414684	0.011628	2.080204
241	(soy lactosefree, packaged cheese)	(fresh fruits)	0.046265	0.555995	0.036390	0.786556	1.414681	0.010667	2.080192
173	(fresh herbs, fresh vegetables)	(fresh fruits)	0.078655	0.555995	0.061815	0.785900	1.413503	0.018083	2.073825
150	(eggs, fresh vegetables)	(fresh fruits)	0.084310	0.555995	0.066145	0.784545	1.411065	0.019269	2.060780
127	(packaged vegetables fruits, chips pretzels)	(fresh fruits)	0.073545	0.555995	0.057595	0.783126	1.408513	0.016704	2.047295
234	(milk, yogurt)	(fresh fruits)	0.095705	0.555995	0.074860	0.782195	1.406839	0.021648	2.038546
206	(fresh vegetables, refrigerated)	(fresh fruits)	0.065825	0.555995	0.051445	0.781542	1.405664	0.014847	2.032450
275	(packaged vegetables fruits, soup broth bouillon)	(fresh vegetables)	0.041045	0.444360	0.032055	0.780972	1.757521	0.013816	2.536846
237	(packaged vegetables fruits, other creams chee...	(fresh fruits)	0.040265	0.555995	0.031435	0.780703	1.404154	0.009048	2.024673
221	(hot dogs bacon sausage, packaged vegetables f...	(fresh fruits)	0.040315	0.555995	0.031455	0.780231	1.403305	0.009040	2.020323
141	(crackers, yogurt)	(fresh fruits)	0.043040	0.555995	0.033385	0.775674	1.395109	0.009455	1.979283
124	(chips pretzels, fresh vegetables)	(fresh fruits)	0.082245	0.555995	0.063685	0.774333	1.392697	0.017957	1.967521
311	(eggs, packaged vegetables fruits, fresh fruits)	(fresh vegetables)	0.055045	0.444360	0.042555	0.773095	1.739794	0.018095	2.448775
185	(juice nectars, fresh vegetables)	(fresh fruits)	0.042775	0.555995	0.033055	0.772764	1.389877	0.009272	1.953942
129	(chips pretzels, yogurt)	(fresh fruits)	0.056980	0.555995	0.044025	0.772640	1.389652	0.012344	1.952868
400	(packaged cheese, packaged vegetables fruits, ...	(fresh vegetables)	0.044825	0.444360	0.034565	0.771110	1.735327	0.014647	2.427540
197	(packaged cheese, fresh vegetables)	(fresh fruits)	0.135850	0.555995	0.104570	0.769746	1.384448	0.029038	1.928327
250	(water seltzer sparkling water, packaged veget...	(fresh fruits)	0.073715	0.555995	0.056550	0.767144	1.379767	0.015565	1.906777
203	(pasta sauce, fresh vegetables)	(fresh fruits)	0.041005	0.555995	0.031430	0.766492	1.378595	0.008631	1.901454
229	(milk, packaged cheese)	(fresh fruits)	0.078170	0.555995	0.059885	0.766087	1.377866	0.016423	1.898161
10	(canned jarred vegetables)	(fresh vegetables)	0.071890	0.444360	0.055055	0.765823	1.723429	0.023110	2.372733
246	(packaged vegetables fruits, soup broth bouillon)	(fresh fruits)	0.041045	0.555995	0.031405	0.765136	1.376156	0.008584	1.890476
147	(dry pasta, fresh vegetables)	(fresh fruits)	0.047235	0.555995	0.036115	0.764581	1.375159	0.009853	1.886023
254	(yogurt, refrigerated)	(fresh fruits)	0.047175	0.555995	0.036030	0.763752	1.373667	0.009801	1.879402
151	(milk, eggs)	(fresh fruits)	0.047795	0.555995	0.036475	0.763155	1.372594	0.009901	1.874666
232	(milk, soy lactosefree)	(fresh fruits)	0.041220	0.555995	0.031440	0.762737	1.371841	0.008522	1.871358
106	(butter, fresh vegetables)	(fresh fruits)	0.044580	0.555995	0.033965	0.761889	1.370316	0.009179	1.864696
327	(frozen produce, packaged vegetables fruits, f...	(fresh vegetables)	0.054415	0.444360	0.041445	0.761647	1.714031	0.017265	2.331160
207	(soup broth bouillon, fresh fruits)	(fresh vegetables)	0.053880	0.444360	0.040940	0.759837	1.709957	0.016998	2.313592
214	(water seltzer sparkling water, fresh vegetables)	(fresh fruits)	0.083355	0.555995	0.063235	0.758623	1.364442	0.016890	1.839465
152	(eggs, packaged cheese)	(fresh fruits)	0.045435	0.555995	0.034460	0.758446	1.364124	0.009198	1.838120
145	(cream, fresh vegetables)	(fresh fruits)	0.044830	0.555995	0.033990	0.758198	1.363677	0.009065	1.836231
223	(packaged vegetables fruits, ice cream ice)	(fresh fruits)	0.043735	0.555995	0.033125	0.757403	1.362247	0.008809	1.830213
92	(milk, bread)	(fresh fruits)	0.059705	0.555995	0.045210	0.757223	1.361924	0.012014	1.828860
324	(packaged vegetables fruits, fresh herbs)	(fresh fruits, fresh vegetables)	0.052535	0.317560	0.039660	0.754925	2.377268	0.022977	2.784620
33	(fresh herbs)	(fresh fruits)	0.093005	0.555995	0.070135	0.754099	1.356306	0.018425	1.805627
348	(packaged cheese, packaged vegetables fruits, ...	(fresh vegetables)	0.090715	0.444360	0.068325	0.753183	1.694984	0.028015	2.251223
181	(hot dogs bacon sausage, fresh vegetables)	(fresh fruits)	0.049460	0.555995	0.037215	0.752426	1.353297	0.009715	1.793425
146	(dry pasta, fresh fruits)	(fresh vegetables)	0.048095	0.444360	0.036115	0.750910	1.689868	0.014744	2.230677
195	(other creams cheeses, fresh vegetables)	(fresh fruits)	0.052105	0.555995	0.039015	0.748777	1.346732	0.010045	1.767371
93	(bread, packaged cheese)	(fresh fruits)	0.059690	0.555995	0.044665	0.748283	1.345844	0.011478	1.763904
316	(packaged vegetables fruits, fresh fruits, fre...	(fresh vegetables)	0.043245	0.444360	0.032265	0.746098	1.679039	0.013049	2.188402
256	(water seltzer sparkling water, yogurt)	(fresh fruits)	0.056185	0.555995	0.041895	0.745662	1.341130	0.010656	1.745726
0	(baby food formula)	(fresh fruits)	0.045355	0.555995	0.033810	0.745453	1.340754	0.008593	1.744292
183	(ice cream ice, fresh vegetables)	(fresh fruits)	0.051995	0.555995	0.038700	0.744302	1.338685	0.009791	1.736445
391	(packaged cheese, packaged vegetables fruits, ...	(fresh vegetables)	0.051915	0.444360	0.038635	0.744197	1.674762	0.015566	2.172142
108	(canned jarred vegetables, fresh vegetables)	(fresh fruits)	0.055055	0.555995	0.040955	0.743892	1.337948	0.010345	1.733666
332	(lunch meat, packaged vegetables fruits, fresh...	(fresh vegetables)	0.043000	0.444360	0.031940	0.742791	1.671597	0.012833	2.160264
193	(oils vinegars, fresh vegetables)	(fresh fruits)	0.042610	0.555995	0.031600	0.741610	1.333843	0.007909	1.718352
89	(baking ingredients, fresh vegetables)	(fresh fruits)	0.043790	0.555995	0.032470	0.741493	1.333633	0.008123	1.717578
225	(lunch meat, packaged cheese)	(fresh fruits)	0.045205	0.555995	0.033515	0.741400	1.333466	0.008381	1.716959
360	(soy lactosefree, packaged vegetables fruits, ...	(fresh vegetables)	0.066960	0.444360	0.049600	0.740741	1.666983	0.019846	2.143183
208	(soup broth bouillon, fresh vegetables)	(fresh fruits)	0.055380	0.555995	0.040940	0.739256	1.329609	0.010149	1.702839
53	(packaged vegetables fruits)	(fresh fruits)	0.365415	0.555995	0.269870	0.738530	1.328304	0.066701	1.698112
158	(eggs, packaged vegetables fruits)	(fresh vegetables)	0.068650	0.444360	0.050675	0.738165	1.661186	0.020170	2.122097
192	(oils vinegars, fresh fruits)	(fresh vegetables)	0.042885	0.444360	0.031600	0.736854	1.658237	0.012544	2.111530
394	(milk, packaged vegetables fruits, fresh fruit...	(fresh vegetables)	0.044575	0.444360	0.032845	0.736848	1.658223	0.013038	2.111479
125	(milk, chips pretzels)	(fresh fruits)	0.048915	0.555995	0.036000	0.735971	1.323700	0.008804	1.681650
292	(bread, packaged vegetables fruits, fresh fruits)	(fresh vegetables)	0.062430	0.444360	0.045910	0.735384	1.654928	0.018169	2.099795
138	(packaged cheese, crackers)	(fresh fruits)	0.043875	0.555995	0.032260	0.735271	1.322441	0.007866	1.677204
387	(milk, packaged cheese, packaged vegetables fr...	(fresh vegetables)	0.043830	0.444360	0.032215	0.734999	1.654062	0.012739	2.096746
202	(fresh fruits, pasta sauce)	(fresh vegetables)	0.042840	0.444360	0.031430	0.733660	1.651049	0.012394	2.086207
260	(frozen produce, packaged vegetables fruits)	(fresh vegetables)	0.066985	0.444360	0.048895	0.729940	1.642676	0.019130	2.057465
39	(frozen produce)	(fresh fruits)	0.122580	0.555995	0.089235	0.727974	1.309317	0.021081	1.632213
13	(canned meals beans)	(fresh vegetables)	0.069705	0.444360	0.050435	0.723549	1.628295	0.019461	2.009906
233	(milk, water seltzer sparkling water)	(fresh fruits)	0.046610	0.555995	0.033700	0.723021	1.300409	0.007785	1.603027
369	(packaged vegetables fruits, fresh fruits, yog...	(fresh vegetables)	0.105790	0.444360	0.076240	0.720673	1.621822	0.029231	1.989210
126	(packaged cheese, chips pretzels)	(fresh fruits)	0.056405	0.555995	0.040565	0.719174	1.293490	0.009204	1.581067
242	(water seltzer sparkling water, packaged cheese)	(fresh fruits)	0.048255	0.555995	0.034565	0.716299	1.288319	0.007735	1.565045
306	(packaged vegetables fruits, fresh fruits, cra...	(fresh vegetables)	0.042385	0.444360	0.030350	0.716055	1.611430	0.011516	1.956859
12	(canned meals beans)	(fresh fruits)	0.069705	0.555995	0.049890	0.715731	1.287297	0.011134	1.561916
269	(packaged cheese, packaged vegetables fruits)	(fresh vegetables)	0.114610	0.444360	0.081970	0.715208	1.609524	0.031042	1.951039
340	(milk, packaged vegetables fruits, fresh fruits)	(fresh vegetables)	0.087450	0.444360	0.062535	0.715094	1.609268	0.023676	1.950260
35	(fresh vegetables)	(fresh fruits)	0.444360	0.555995	0.317560	0.714646	1.285346	0.070498	1.555978
64	(yogurt)	(fresh fruits)	0.263675	0.555995	0.188225	0.713852	1.283919	0.041623	1.551664
389	(milk, packaged vegetables fruits, yogurt)	(fresh vegetables)	0.051295	0.444360	0.036455	0.710693	1.599363	0.013662	1.920590
277	(soy lactosefree, packaged vegetables fruits)	(fresh vegetables)	0.081385	0.444360	0.057695	0.708914	1.595361	0.021531	1.908854
170	(packaged vegetables fruits, fresh dips tapena...	(fresh vegetables)	0.053785	0.444360	0.038095	0.708283	1.593940	0.014195	1.904723
263	(lunch meat, packaged vegetables fruits)	(fresh vegetables)	0.053225	0.444360	0.037600	0.706435	1.589781	0.013949	1.892732
41	(hot cereal pancake mixes)	(fresh fruits)	0.045025	0.555995	0.031740	0.704942	1.267892	0.006706	1.504804
402	(yogurt, fresh fruits, packaged cheese, fresh ...	(packaged vegetables fruits)	0.049105	0.365415	0.034565	0.703900	1.926302	0.016621	2.143143
30	(fresh dips tapenades)	(fresh fruits)	0.098205	0.555995	0.069040	0.703019	1.264434	0.014439	1.495063
81	(spices seasonings)	(fresh vegetables)	0.052165	0.444360	0.036660	0.702770	1.581533	0.013480	1.869394
353	(packaged cheese, fresh fruits, yogurt)	(fresh vegetables)	0.070020	0.444360	0.049105	0.701300	1.578224	0.017991	1.860192
289	(bread, packaged cheese, fresh fruits)	(fresh vegetables)	0.044665	0.444360	0.031275	0.700213	1.575778	0.011428	1.853447
302	(packaged vegetables fruits, chips pretzels, f...	(fresh vegetables)	0.057595	0.444360	0.040325	0.700148	1.575631	0.014732	1.853045
99	(bread, packaged vegetables fruits)	(fresh vegetables)	0.077055	0.444360	0.053835	0.698657	1.572277	0.019595	1.843878
26	(eggs)	(fresh fruits)	0.136490	0.555995	0.095325	0.698403	1.256131	0.019437	1.472179
58	(soy lactosefree)	(fresh fruits)	0.168355	0.555995	0.117480	0.697811	1.255067	0.023875	1.469297
177	(frozen produce, fresh fruits)	(fresh vegetables)	0.089235	0.444360	0.062170	0.696700	1.567872	0.022518	1.831980
356	(packaged vegetables fruits, fresh fruits, ref...	(fresh vegetables)	0.046595	0.444360	0.032460	0.696641	1.567741	0.011755	1.831627
46	(lunch meat)	(fresh fruits)	0.103890	0.555995	0.072290	0.695832	1.251508	0.014528	1.459737
62	(tortillas flat bread)	(fresh fruits)	0.056455	0.555995	0.039205	0.694447	1.249016	0.007816	1.453119
105	(butter, fresh fruits)	(fresh vegetables)	0.048920	0.444360	0.033965	0.694297	1.562465	0.012227	1.817580
149	(eggs, fresh fruits)	(fresh vegetables)	0.095325	0.444360	0.066145	0.693889	1.561548	0.023786	1.815160
337	(milk, packaged cheese, fresh fruits)	(fresh vegetables)	0.059885	0.444360	0.041475	0.692577	1.558595	0.014865	1.807415
318	(fresh fruits, fresh dips tapenades, fresh veg...	(packaged vegetables fruits)	0.046625	0.365415	0.032265	0.692011	1.893767	0.015228	2.060413
262	(frozen produce, yogurt)	(fresh vegetables)	0.045295	0.444360	0.031330	0.691688	1.556593	0.011203	1.802199
198	(packaged vegetables fruits, fresh fruits)	(fresh vegetables)	0.269870	0.444360	0.186580	0.691370	1.555878	0.066661	1.800343
194	(other creams cheeses, fresh fruits)	(fresh vegetables)	0.056630	0.444360	0.039015	0.688946	1.550423	0.013851	1.786312
281	(packaged vegetables fruits, yogurt)	(fresh vegetables)	0.127910	0.444360	0.087995	0.687945	1.548170	0.031157	1.780582
37	(frozen breakfast)	(fresh fruits)	0.061165	0.555995	0.042035	0.687239	1.236053	0.008028	1.419632
29	(energy granola bars)	(fresh fruits)	0.086545	0.555995	0.059450	0.686926	1.235489	0.011331	1.418210
23	(dry pasta)	(fresh fruits)	0.070055	0.555995	0.048095	0.686532	1.234781	0.009145	1.416429
88	(baking ingredients, fresh fruits)	(fresh vegetables)	0.047305	0.444360	0.032470	0.686397	1.544686	0.011450	1.771793
3	(bread)	(fresh fruits)	0.163865	0.555995	0.112410	0.685992	1.233809	0.021302	1.413990
157	(eggs, packaged cheese)	(fresh vegetables)	0.045435	0.444360	0.031160	0.685815	1.543377	0.010971	1.768512
60	(spreads)	(fresh fruits)	0.078185	0.555995	0.053560	0.685042	1.232101	0.010090	1.409727
180	(hot dogs bacon sausage, fresh fruits)	(fresh vegetables)	0.054425	0.444360	0.037215	0.683785	1.538809	0.013031	1.757159
55	(pasta sauce)	(fresh fruits)	0.062660	0.555995	0.042840	0.683690	1.229669	0.008001	1.403701
365	(water seltzer sparkling water, packaged veget...	(fresh vegetables)	0.056550	0.444360	0.038645	0.683378	1.537892	0.013516	1.754898
40	(fruit vegetable snacks)	(fresh fruits)	0.046085	0.555995	0.031460	0.682652	1.227802	0.005837	1.399109
48	(nuts seeds dried fruit)	(fresh fruits)	0.080225	0.555995	0.054750	0.682456	1.227449	0.010145	1.398245
297	(bread, fresh fruits, yogurt)	(fresh vegetables)	0.048950	0.444360	0.033370	0.681716	1.534153	0.011619	1.745737
266	(milk, packaged vegetables fruits)	(fresh vegetables)	0.107425	0.444360	0.073075	0.680242	1.530835	0.025340	1.737689
9	(canned jarred vegetables)	(fresh fruits)	0.071890	0.555995	0.048880	0.679928	1.222902	0.008910	1.387202
392	(packaged cheese, fresh vegetables, yogurt)	(packaged vegetables fruits)	0.057195	0.365415	0.038635	0.675496	1.848572	0.017735	1.955554
165	(fresh fruits, fresh dips tapenades)	(fresh vegetables)	0.069040	0.444360	0.046625	0.675333	1.519788	0.015946	1.711416
47	(milk)	(fresh fruits)	0.243325	0.555995	0.164310	0.675270	1.214525	0.029023	1.367304
51	(packaged cheese)	(fresh fruits)	0.230995	0.555995	0.155900	0.674906	1.213871	0.027468	1.365776
24	(dry pasta)	(fresh vegetables)	0.070055	0.444360	0.047235	0.674256	1.517364	0.016105	1.705756
5	(breakfast bakery)	(fresh fruits)	0.067765	0.555995	0.045680	0.674094	1.212411	0.008003	1.362373
396	(milk, yogurt, fresh fruits, fresh vegetables)	(packaged vegetables fruits)	0.048835	0.365415	0.032845	0.672571	1.840567	0.015000	1.938084
374	(soy lactosefree, fresh fruits, yogurt)	(fresh vegetables)	0.046075	0.444360	0.030910	0.670863	1.509728	0.010436	1.688171
196	(packaged cheese, fresh fruits)	(fresh vegetables)	0.155900	0.444360	0.104570	0.670750	1.509475	0.035294	1.687595
160	(eggs, yogurt)	(fresh vegetables)	0.049905	0.444360	0.033470	0.670674	1.509304	0.011294	1.687205
142	(packaged vegetables fruits, crackers)	(fresh vegetables)	0.052650	0.444360	0.035225	0.669041	1.505628	0.011829	1.678878
334	(lunch meat, fresh fruits, fresh vegetables)	(packaged vegetables fruits)	0.047870	0.365415	0.031940	0.667224	1.825934	0.014448	1.906942
329	(frozen produce, fresh fruits, fresh vegetables)	(packaged vegetables fruits)	0.062170	0.365415	0.041445	0.666640	1.824336	0.018727	1.903602
403	(packaged cheese, packaged vegetables fruits, ...	(fresh fruits, fresh vegetables)	0.051915	0.317560	0.034565	0.665800	2.096611	0.018079	2.042010
174	(fresh herbs)	(fresh fruits, fresh vegetables)	0.093005	0.317560	0.061815	0.664642	2.092964	0.032280	2.034958
79	(soup broth bouillon)	(fresh vegetables)	0.083365	0.444360	0.055380	0.664308	1.494976	0.018336	1.655206
186	(lunch meat, fresh fruits)	(fresh vegetables)	0.072290	0.444360	0.047870	0.662194	1.490220	0.015747	1.644849
308	(fresh fruits, crackers, fresh vegetables)	(packaged vegetables fruits)	0.045875	0.365415	0.030350	0.661580	1.810490	0.013587	1.875142
6	(butter)	(fresh fruits)	0.074330	0.555995	0.048920	0.658146	1.183727	0.007593	1.298815
171	(fresh dips tapenades, fresh vegetables)	(packaged vegetables fruits)	0.057955	0.365415	0.038095	0.657320	1.798832	0.016917	1.851832
21	(crackers)	(fresh fruits)	0.114970	0.555995	0.075480	0.656519	1.180800	0.011557	1.292663
362	(soy lactosefree, fresh fruits, fresh vegetables)	(packaged vegetables fruits)	0.075620	0.365415	0.049600	0.655911	1.794976	0.021967	1.844247
271	(soy lactosefree, packaged cheese)	(fresh vegetables)	0.046265	0.444360	0.030345	0.655895	1.476045	0.009787	1.614741
273	(packaged vegetables fruits, refrigerated)	(fresh vegetables)	0.058705	0.444360	0.038470	0.655310	1.474729	0.012384	1.612001
50	(other creams cheeses)	(fresh fruits)	0.086485	0.555995	0.056630	0.654796	1.177701	0.008545	1.286209
78	(pasta sauce)	(fresh vegetables)	0.062660	0.444360	0.041005	0.654405	1.472690	0.013161	1.607777
131	(packaged vegetables fruits, chips pretzels)	(fresh vegetables)	0.073545	0.444360	0.048105	0.654089	1.471981	0.015425	1.606311
350	(packaged cheese, fresh fruits, fresh vegetables)	(packaged vegetables fruits)	0.104570	0.365415	0.068325	0.653390	1.788077	0.030114	1.830833
388	(milk, packaged cheese, fresh vegetables)	(packaged vegetables fruits)	0.049305	0.365415	0.032215	0.653382	1.788055	0.014198	1.830791
345	(milk, fresh fruits, yogurt)	(fresh vegetables)	0.074860	0.444360	0.048835	0.652351	1.468069	0.015570	1.598279
44	(instant foods)	(fresh fruits)	0.051995	0.555995	0.033840	0.650832	1.170571	0.004931	1.271608
83	(tortillas flat bread)	(fresh vegetables)	0.056455	0.444360	0.036525	0.646975	1.455971	0.011439	1.573942
42	(hot dogs bacon sausage)	(fresh fruits)	0.084190	0.555995	0.054425	0.646454	1.162698	0.007616	1.255864
57	(soup broth bouillon)	(fresh fruits)	0.083365	0.555995	0.053880	0.646314	1.162446	0.007529	1.255366
272	(packaged cheese, yogurt)	(fresh vegetables)	0.088520	0.444360	0.057195	0.646125	1.454058	0.017860	1.570160
390	(milk, fresh vegetables, yogurt)	(packaged vegetables fruits)	0.056510	0.365415	0.036455	0.645107	1.765409	0.015805	1.788103
56	(refrigerated)	(fresh fruits)	0.134040	0.555995	0.086430	0.644808	1.159736	0.011904	1.250041
15	(cereal)	(fresh fruits)	0.092560	0.555995	0.059620	0.644123	1.158505	0.008157	1.247635
371	(fresh fruits, fresh vegetables, yogurt)	(packaged vegetables fruits)	0.118420	0.365415	0.076240	0.643810	1.761860	0.032968	1.781592
90	(bread, fresh fruits)	(fresh vegetables)	0.112410	0.444360	0.072365	0.643759	1.448734	0.022414	1.559733
209	(soy lactosefree, fresh fruits)	(fresh vegetables)	0.117480	0.444360	0.075620	0.643684	1.448564	0.023417	1.559402
313	(eggs, fresh fruits, fresh vegetables)	(packaged vegetables fruits)	0.066145	0.365415	0.042555	0.643359	1.760626	0.018385	1.779340
76	(packaged vegetables fruits)	(fresh vegetables)	0.365415	0.444360	0.234555	0.641887	1.444519	0.072179	1.551576
323	(fresh fruits, fresh herbs, fresh vegetables)	(packaged vegetables fruits)	0.061815	0.365415	0.039660	0.641592	1.755790	0.017072	1.770565
156	(milk, eggs)	(fresh vegetables)	0.047795	0.444360	0.030660	0.641490	1.443626	0.009422	1.549858
52	(packaged produce)	(fresh fruits)	0.062270	0.555995	0.039945	0.641481	1.153753	0.005323	1.238441
397	(milk, packaged vegetables fruits, yogurt)	(fresh fruits, fresh vegetables)	0.051295	0.317560	0.032845	0.640316	2.016362	0.016556	1.897331
385	(packaged cheese, fresh fruits, yogurt)	(packaged vegetables fruits)	0.070020	0.365415	0.044825	0.640174	1.751910	0.019239	1.763590
279	(water seltzer sparkling water, packaged veget...	(fresh vegetables)	0.073715	0.444360	0.047105	0.639015	1.438057	0.014349	1.539233
59	(spices seasonings)	(fresh fruits)	0.052165	0.555995	0.033220	0.636825	1.145380	0.004217	1.222566
36	(frozen appetizers sides)	(fresh fruits)	0.051875	0.555995	0.033035	0.636819	1.145369	0.004193	1.222546
49	(oils vinegars)	(fresh fruits)	0.067350	0.555995	0.042885	0.636748	1.145241	0.005439	1.222307
294	(bread, fresh fruits, fresh vegetables)	(packaged vegetables fruits)	0.072365	0.365415	0.045910	0.634423	1.736170	0.019467	1.735844
68	(frozen produce)	(fresh vegetables)	0.122580	0.444360	0.077750	0.634280	1.427400	0.023280	1.519303
304	(chips pretzels, fresh fruits, fresh vegetables)	(packaged vegetables fruits)	0.063685	0.365415	0.040325	0.633195	1.732810	0.017054	1.730032
73	(oils vinegars)	(fresh vegetables)	0.067350	0.444360	0.042610	0.632665	1.423767	0.012682	1.512625
98	(bread, packaged cheese)	(fresh vegetables)	0.059690	0.444360	0.037740	0.632267	1.422870	0.011216	1.510986
358	(refrigerated, fresh fruits, fresh vegetables)	(packaged vegetables fruits)	0.051445	0.365415	0.032460	0.630965	1.726708	0.013661	1.719580
265	(milk, packaged cheese)	(fresh vegetables)	0.078170	0.444360	0.049305	0.630741	1.419436	0.014569	1.504742
215	(fresh fruits, yogurt)	(fresh vegetables)	0.188225	0.444360	0.118420	0.629141	1.415835	0.034780	1.498250
261	(frozen produce, fresh vegetables)	(packaged vegetables fruits)	0.077750	0.365415	0.048895	0.628875	1.720987	0.020484	1.709894
342	(milk, fresh fruits, fresh vegetables)	(packaged vegetables fruits)	0.099590	0.365415	0.062535	0.627924	1.718387	0.026143	1.705527
190	(nuts seeds dried fruit, fresh fruits)	(fresh vegetables)	0.054750	0.444360	0.034350	0.627397	1.411912	0.010021	1.491240
16	(chips pretzels)	(fresh fruits)	0.169435	0.555995	0.106300	0.627379	1.128390	0.012095	1.191573
168	(fresh fruits, fresh dips tapenades)	(packaged vegetables fruits)	0.069040	0.365415	0.043245	0.626376	1.714150	0.018017	1.698459
264	(lunch meat, fresh vegetables)	(packaged vegetables fruits)	0.060095	0.365415	0.037600	0.625676	1.712234	0.015640	1.695283
378	(milk, packaged cheese, fresh fruits)	(packaged vegetables fruits)	0.059885	0.365415	0.037380	0.624196	1.708185	0.015497	1.688608
101	(bread, yogurt)	(fresh vegetables)	0.061840	0.444360	0.038560	0.623545	1.403242	0.011081	1.475978
22	(cream)	(fresh fruits)	0.091605	0.555995	0.057010	0.622346	1.119337	0.006078	1.175692
45	(juice nectars)	(fresh fruits)	0.089395	0.555995	0.055600	0.621959	1.118641	0.005897	1.174488
176	(fresh fruits, fresh herbs)	(packaged vegetables fruits)	0.070135	0.365415	0.043490	0.620090	1.696947	0.017862	1.670355
314	(eggs, packaged vegetables fruits)	(fresh fruits, fresh vegetables)	0.068650	0.317560	0.042555	0.619883	1.952020	0.020755	1.795344
18	(condiments)	(fresh fruits)	0.059465	0.555995	0.036830	0.619356	1.113960	0.003768	1.166457
330	(frozen produce, packaged vegetables fruits)	(fresh fruits, fresh vegetables)	0.066985	0.317560	0.041445	0.618721	1.948358	0.020173	1.789869
301	(bread, fresh fruits, yogurt)	(packaged vegetables fruits)	0.048950	0.365415	0.030265	0.618284	1.692005	0.012378	1.662453
27	(eggs)	(fresh vegetables)	0.136490	0.444360	0.084310	0.617701	1.390091	0.023659	1.453417
1	(baking ingredients)	(fresh fruits)	0.076635	0.555995	0.047305	0.617277	1.110220	0.004696	1.160120
143	(crackers, fresh vegetables)	(packaged vegetables fruits)	0.057335	0.365415	0.035225	0.614372	1.681298	0.014274	1.645587
211	(fresh fruits, spreads)	(fresh vegetables)	0.053560	0.444360	0.032885	0.613984	1.381727	0.009085	1.439423
278	(soy lactosefree, fresh vegetables)	(packaged vegetables fruits)	0.094120	0.365415	0.057695	0.612994	1.677528	0.023302	1.639729
116	(canned meals beans, fresh fruits)	(packaged vegetables fruits)	0.049890	0.365415	0.030560	0.612548	1.676307	0.012329	1.637840
283	(soy lactosefree, yogurt)	(fresh vegetables)	0.058195	0.444360	0.035635	0.612338	1.378022	0.009775	1.433310
367	(water seltzer sparkling water, fresh fruits, ...	(packaged vegetables fruits)	0.063235	0.365415	0.038645	0.611133	1.672436	0.015538	1.631882
19	(condiments)	(fresh vegetables)	0.059465	0.444360	0.036290	0.610275	1.373380	0.009866	1.425723
219	(frozen produce, fresh fruits)	(packaged vegetables fruits)	0.089235	0.365415	0.054415	0.609794	1.668772	0.021807	1.626284
363	(soy lactosefree, packaged vegetables fruits)	(fresh fruits, fresh vegetables)	0.081385	0.317560	0.049600	0.609449	1.919161	0.023755	1.747377
282	(fresh vegetables, yogurt)	(packaged vegetables fruits)	0.144660	0.365415	0.087995	0.608288	1.664651	0.035134	1.620031
136	(fresh fruits, crackers)	(fresh vegetables)	0.075480	0.444360	0.045875	0.607777	1.367758	0.012335	1.416643
188	(milk, fresh fruits)	(fresh vegetables)	0.164310	0.444360	0.099590	0.606110	1.364008	0.026577	1.410649
118	(canned meals beans, fresh vegetables)	(packaged vegetables fruits)	0.050435	0.365415	0.030555	0.605829	1.657921	0.012125	1.609924
404	(packaged cheese, yogurt, fresh vegetables)	(packaged vegetables fruits, fresh fruits)	0.057195	0.269870	0.034565	0.604336	2.239360	0.019130	1.845329
270	(packaged cheese, fresh vegetables)	(packaged vegetables fruits)	0.135850	0.365415	0.081970	0.603386	1.651235	0.032328	1.600007
74	(other creams cheeses)	(fresh vegetables)	0.086485	0.444360	0.052105	0.602474	1.355825	0.013675	1.397747
159	(eggs, fresh vegetables)	(packaged vegetables fruits)	0.084310	0.365415	0.050675	0.601056	1.644858	0.019867	1.590660
182	(fresh fruits, ice cream ice)	(fresh vegetables)	0.064485	0.444360	0.038700	0.600140	1.350571	0.010045	1.389585
335	(lunch meat, packaged vegetables fruits)	(fresh fruits, fresh vegetables)	0.053225	0.317560	0.031940	0.600094	1.889703	0.015038	1.706501
319	(packaged vegetables fruits, fresh dips tapena...	(fresh fruits, fresh vegetables)	0.053785	0.317560	0.032265	0.599888	1.889055	0.015185	1.705624
7	(butter)	(fresh vegetables)	0.074330	0.444360	0.044580	0.599758	1.349712	0.011551	1.388260
123	(chips pretzels, fresh fruits)	(fresh vegetables)	0.106300	0.444360	0.063685	0.599106	1.348245	0.016450	1.386003
258	(fresh herbs, fresh vegetables)	(packaged vegetables fruits)	0.078655	0.365415	0.046980	0.597292	1.634558	0.018238	1.575794
144	(fresh fruits, cream)	(fresh vegetables)	0.057010	0.444360	0.033990	0.596211	1.341730	0.008657	1.376066
351	(packaged cheese, packaged vegetables fruits)	(fresh fruits, fresh vegetables)	0.114610	0.317560	0.068325	0.596152	1.877290	0.031929	1.689844
372	(packaged vegetables fruits, yogurt)	(fresh fruits, fresh vegetables)	0.127910	0.317560	0.076240	0.596044	1.876950	0.035621	1.689392
295	(bread, packaged vegetables fruits)	(fresh fruits, fresh vegetables)	0.077055	0.317560	0.045910	0.595808	1.876207	0.021440	1.688406
383	(milk, fresh fruits, yogurt)	(packaged vegetables fruits)	0.074860	0.365415	0.044575	0.595445	1.629503	0.017220	1.568599
205	(fresh fruits, refrigerated)	(fresh vegetables)	0.086430	0.444360	0.051445	0.595222	1.339503	0.013039	1.372702
227	(lunch meat, fresh fruits)	(packaged vegetables fruits)	0.072290	0.365415	0.043000	0.594826	1.627811	0.016584	1.566205
130	(packaged cheese, chips pretzels)	(fresh vegetables)	0.056405	0.444360	0.033535	0.594539	1.337968	0.008471	1.370392
184	(juice nectars, fresh fruits)	(fresh vegetables)	0.055600	0.444360	0.033055	0.594514	1.337912	0.008349	1.370308
38	(frozen meals)	(fresh fruits)	0.074330	0.555995	0.044090	0.593166	1.066854	0.002763	1.091365
97	(milk, bread)	(fresh vegetables)	0.059705	0.444360	0.035350	0.592078	1.332428	0.008819	1.362122
61	(tea)	(fresh fruits)	0.057010	0.555995	0.033720	0.591475	1.063814	0.002023	1.086850
268	(milk, yogurt)	(fresh vegetables)	0.095705	0.444360	0.056510	0.590460	1.328788	0.013983	1.356743
31	(fresh dips tapenades)	(fresh vegetables)	0.098205	0.444360	0.057955	0.590143	1.328074	0.014317	1.355693
75	(packaged cheese)	(fresh vegetables)	0.230995	0.444360	0.135850	0.588108	1.323494	0.033205	1.348994
100	(bread, fresh vegetables)	(packaged vegetables fruits)	0.091590	0.365415	0.053835	0.587783	1.608534	0.020367	1.539442
200	(fresh fruits, fresh vegetables)	(packaged vegetables fruits)	0.317560	0.365415	0.186580	0.587543	1.607877	0.070539	1.538546
69	(hot dogs bacon sausage)	(fresh vegetables)	0.084190	0.444360	0.049460	0.587481	1.322083	0.012049	1.346943
287	(packaged cheese, yogurt)	(packaged vegetables fruits)	0.088520	0.365415	0.051915	0.586478	1.604963	0.019568	1.534584
267	(milk, fresh vegetables)	(packaged vegetables fruits)	0.124715	0.365415	0.073075	0.585936	1.603481	0.027502	1.532577
132	(chips pretzels, fresh vegetables)	(packaged vegetables fruits)	0.082245	0.365415	0.048105	0.584899	1.600642	0.018051	1.528748
119	(cereal, fresh fruits)	(fresh vegetables)	0.059620	0.444360	0.034865	0.584787	1.316021	0.008372	1.338205
274	(fresh vegetables, refrigerated)	(packaged vegetables fruits)	0.065825	0.365415	0.038470	0.584428	1.599355	0.014417	1.527017
43	(ice cream ice)	(fresh fruits)	0.110510	0.555995	0.064485	0.583522	1.049509	0.003042	1.066094
247	(soup broth bouillon, fresh fruits)	(packaged vegetables fruits)	0.053880	0.365415	0.031405	0.582869	1.595089	0.011716	1.521310
343	(milk, packaged vegetables fruits)	(fresh fruits, fresh vegetables)	0.107425	0.317560	0.062535	0.582127	1.833125	0.028421	1.633128
240	(packaged cheese, fresh fruits)	(packaged vegetables fruits)	0.155900	0.365415	0.090715	0.581879	1.592380	0.033747	1.517708
398	(milk, yogurt, fresh vegetables)	(packaged vegetables fruits, fresh fruits)	0.056510	0.269870	0.032845	0.581225	2.153721	0.017595	1.743488
111	(canned jarred vegetables, fresh vegetables)	(packaged vegetables fruits)	0.055055	0.365415	0.031925	0.579875	1.586893	0.011807	1.510466
20	(cookies cakes)	(fresh fruits)	0.059725	0.555995	0.034610	0.579489	1.042256	0.001403	1.055871
276	(soup broth bouillon, fresh vegetables)	(packaged vegetables fruits)	0.055380	0.365415	0.032055	0.578819	1.584005	0.011818	1.506680
70	(lunch meat)	(fresh vegetables)	0.103890	0.444360	0.060095	0.578448	1.301756	0.013930	1.318083
222	(hot dogs bacon sausage, fresh fruits)	(packaged vegetables fruits)	0.054425	0.365415	0.031455	0.577951	1.581630	0.011567	1.503582
154	(eggs, fresh fruits)	(packaged vegetables fruits)	0.095325	0.365415	0.055045	0.577446	1.580246	0.020212	1.501783
133	(chips pretzels, yogurt)	(fresh vegetables)	0.056980	0.444360	0.032885	0.577132	1.298795	0.007565	1.313981
236	(nuts seeds dried fruit, fresh fruits)	(packaged vegetables fruits)	0.054750	0.365415	0.031575	0.576712	1.578239	0.011569	1.499181
309	(packaged vegetables fruits, crackers)	(fresh fruits, fresh vegetables)	0.052650	0.317560	0.030350	0.576448	1.815242	0.013630	1.611232
63	(water seltzer sparkling water)	(fresh fruits)	0.193005	0.555995	0.111045	0.575348	1.034807	0.003735	1.045573
8	(candy chocolate)	(fresh fruits)	0.069305	0.555995	0.039820	0.574562	1.033394	0.001287	1.043641
17	(coffee)	(fresh fruits)	0.055650	0.555995	0.031855	0.572417	1.029536	0.000914	1.038406
2	(baking ingredients)	(fresh vegetables)	0.076635	0.444360	0.043790	0.571410	1.285917	0.009736	1.296437
34	(fresh fruits)	(fresh vegetables)	0.555995	0.444360	0.317560	0.571156	1.285346	0.070498	1.295670
249	(soy lactosefree, fresh fruits)	(packaged vegetables fruits)	0.117480	0.365415	0.066960	0.569969	1.559786	0.024031	1.475674
109	(canned jarred vegetables)	(fresh fruits, fresh vegetables)	0.071890	0.317560	0.040955	0.569690	1.793960	0.018126	1.585926
213	(water seltzer sparkling water, fresh fruits)	(fresh vegetables)	0.111045	0.444360	0.063235	0.569454	1.281515	0.013891	1.290547
161	(fresh fruits, energy granola bars)	(fresh vegetables)	0.059450	0.444360	0.033845	0.569302	1.281173	0.007428	1.290092
114	(canned meals beans)	(fresh fruits, fresh vegetables)	0.069705	0.317560	0.039670	0.569113	1.792142	0.017534	1.583802
325	(fresh fruits, fresh herbs)	(packaged vegetables fruits, fresh vegetables)	0.070135	0.234555	0.039660	0.565481	2.410867	0.023209	1.761591
280	(water seltzer sparkling water, fresh vegetables)	(packaged vegetables fruits)	0.083355	0.365415	0.047105	0.565113	1.546497	0.016646	1.459195
66	(fresh herbs)	(packaged vegetables fruits)	0.093005	0.365415	0.052535	0.564862	1.545810	0.018550	1.458354
253	(fresh fruits, yogurt)	(packaged vegetables fruits)	0.188225	0.365415	0.105790	0.562040	1.538087	0.037010	1.448957
104	(bread, yogurt)	(packaged vegetables fruits)	0.061840	0.365415	0.034755	0.562015	1.538018	0.012158	1.448873
140	(fresh fruits, crackers)	(packaged vegetables fruits)	0.075480	0.365415	0.042385	0.561539	1.536717	0.014803	1.447302
285	(milk, packaged cheese)	(packaged vegetables fruits)	0.078170	0.365415	0.043830	0.560701	1.534423	0.015266	1.444540
288	(soy lactosefree, yogurt)	(packaged vegetables fruits)	0.058195	0.365415	0.032535	0.559069	1.529955	0.011270	1.439192
80	(soy lactosefree)	(fresh vegetables)	0.168355	0.444360	0.094120	0.559057	1.258117	0.019310	1.260117
4	(bread)	(fresh vegetables)	0.163865	0.444360	0.091590	0.558936	1.257844	0.018775	1.259771
103	(bread, packaged cheese)	(packaged vegetables fruits)	0.059690	0.365415	0.033280	0.557547	1.525792	0.011468	1.434244
320	(fresh dips tapenades, fresh vegetables)	(packaged vegetables fruits, fresh fruits)	0.057955	0.269870	0.032265	0.556725	2.062938	0.016625	1.647127
95	(bread, fresh fruits)	(packaged vegetables fruits)	0.112410	0.365415	0.062430	0.555378	1.519855	0.021354	1.427245
238	(other creams cheeses, fresh fruits)	(packaged vegetables fruits)	0.056630	0.365415	0.031435	0.555094	1.519080	0.010742	1.426337
355	(packaged cheese, yogurt)	(fresh fruits, fresh vegetables)	0.088520	0.317560	0.049105	0.554733	1.746862	0.020995	1.532655
164	(fresh fruits, energy granola bars)	(packaged vegetables fruits)	0.059450	0.365415	0.032945	0.554163	1.516531	0.011221	1.423357
359	(packaged vegetables fruits, refrigerated)	(fresh fruits, fresh vegetables)	0.058705	0.317560	0.032460	0.552934	1.741196	0.013818	1.526487
135	(chips pretzels, yogurt)	(packaged vegetables fruits)	0.056980	0.365415	0.031465	0.552211	1.511189	0.010644	1.417153
84	(yogurt)	(fresh vegetables)	0.263675	0.444360	0.144660	0.548630	1.234652	0.027493	1.231008
305	(packaged vegetables fruits, chips pretzels)	(fresh fruits, fresh vegetables)	0.073545	0.317560	0.040325	0.548304	1.726615	0.016970	1.510838
32	(fresh dips tapenades)	(packaged vegetables fruits)	0.098205	0.365415	0.053785	0.547681	1.498791	0.017899	1.402959
85	(frozen produce)	(packaged vegetables fruits)	0.122580	0.365415	0.066985	0.546459	1.495449	0.022192	1.399180
134	(packaged cheese, chips pretzels)	(packaged vegetables fruits)	0.056405	0.365415	0.030665	0.543657	1.487781	0.010054	1.390589
128	(chips pretzels, fresh fruits)	(packaged vegetables fruits)	0.106300	0.365415	0.057595	0.541816	1.482740	0.018751	1.384999
284	(water seltzer sparkling water, yogurt)	(fresh vegetables)	0.056185	0.444360	0.030395	0.540981	1.217438	0.005429	1.210494
14	(canned meals beans)	(packaged vegetables fruits)	0.069705	0.365415	0.037670	0.540420	1.478922	0.012199	1.380794
299	(bread, yogurt)	(fresh fruits, fresh vegetables)	0.061840	0.317560	0.033370	0.539618	1.699264	0.013732	1.482335
245	(fresh fruits, refrigerated)	(packaged vegetables fruits)	0.086430	0.365415	0.046595	0.539107	1.475327	0.015012	1.376859
379	(milk, packaged cheese, fresh fruits)	(yogurt)	0.059885	0.263675	0.032280	0.539033	2.044309	0.016490	1.597349
286	(milk, yogurt)	(packaged vegetables fruits)	0.095705	0.365415	0.051295	0.535970	1.466743	0.016323	1.367551
331	(frozen produce, fresh vegetables)	(packaged vegetables fruits, fresh fruits)	0.077750	0.269870	0.041445	0.533055	1.975228	0.020463	1.563631
122	(cereal, fresh fruits)	(packaged vegetables fruits)	0.059620	0.365415	0.031780	0.533043	1.458732	0.009994	1.358978
231	(milk, fresh fruits)	(packaged vegetables fruits)	0.164310	0.365415	0.087450	0.532226	1.456497	0.027409	1.356605
336	(lunch meat, fresh vegetables)	(packaged vegetables fruits, fresh fruits)	0.060095	0.269870	0.031940	0.531492	1.969436	0.015722	1.558415
376	(soy lactosefree, yogurt)	(fresh fruits, fresh vegetables)	0.058195	0.317560	0.030910	0.531145	1.672582	0.012430	1.455547
339	(milk, packaged cheese)	(fresh fruits, fresh vegetables)	0.078170	0.317560	0.041475	0.530574	1.670785	0.016651	1.453777
310	(crackers, fresh vegetables)	(packaged vegetables fruits, fresh fruits)	0.057335	0.269870	0.030350	0.529345	1.961482	0.014877	1.551306
77	(fresh vegetables)	(packaged vegetables fruits)	0.444360	0.365415	0.234555	0.527849	1.444519	0.072179	1.344030
67	(frozen breakfast)	(fresh vegetables)	0.061165	0.444360	0.032285	0.527835	1.187853	0.005106	1.176791
373	(fresh vegetables, yogurt)	(packaged vegetables fruits, fresh fruits)	0.144660	0.269870	0.076240	0.527029	1.952899	0.037201	1.543710
364	(soy lactosefree, fresh vegetables)	(packaged vegetables fruits, fresh fruits)	0.094120	0.269870	0.049600	0.526987	1.952743	0.024200	1.543572
11	(canned jarred vegetables)	(packaged vegetables fruits)	0.071890	0.365415	0.037835	0.526290	1.440253	0.011565	1.339607
393	(milk, packaged vegetables fruits, fresh fruit...	(yogurt)	0.062535	0.263675	0.032845	0.525226	1.991944	0.016356	1.550895
368	(water seltzer sparkling water, packaged veget...	(fresh fruits, fresh vegetables)	0.073715	0.317560	0.038645	0.524249	1.650865	0.015236	1.434447
102	(milk, bread)	(packaged vegetables fruits)	0.059705	0.365415	0.031295	0.524160	1.434425	0.009478	1.333611
291	(bread, packaged cheese)	(fresh fruits, fresh vegetables)	0.059690	0.317560	0.031275	0.523957	1.649947	0.012320	1.433568
82	(spreads)	(fresh vegetables)	0.078185	0.444360	0.040795	0.521775	1.174217	0.006053	1.161881
72	(nuts seeds dried fruit)	(fresh vegetables)	0.080225	0.444360	0.041775	0.520723	1.171849	0.006126	1.159329
87	(pasta sauce)	(packaged vegetables fruits)	0.062660	0.365415	0.032595	0.520188	1.423555	0.009698	1.322571
25	(dry pasta)	(packaged vegetables fruits)	0.070055	0.365415	0.036440	0.520163	1.423485	0.010841	1.322500
148	(dry pasta)	(fresh fruits, fresh vegetables)	0.070055	0.317560	0.036115	0.515524	1.623389	0.013868	1.408613
224	(fresh fruits, ice cream ice)	(packaged vegetables fruits)	0.064485	0.365415	0.033125	0.513685	1.405759	0.009561	1.304886
71	(milk)	(fresh vegetables)	0.243325	0.444360	0.124715	0.512545	1.153445	0.016591	1.139879
86	(lunch meat)	(packaged vegetables fruits)	0.103890	0.365415	0.053225	0.512321	1.402024	0.015262	1.301234
201	(packaged vegetables fruits)	(fresh fruits, fresh vegetables)	0.365415	0.317560	0.186580	0.510598	1.607877	0.070539	1.394435
347	(milk, yogurt)	(fresh fruits, fresh vegetables)	0.095705	0.317560	0.048835	0.510266	1.606833	0.018443	1.393491
381	(milk, packaged vegetables fruits, fresh fruits)	(yogurt)	0.087450	0.263675	0.044575	0.509720	1.933137	0.021517	1.501845
251	(water seltzer sparkling water, fresh fruits)	(packaged vegetables fruits)	0.111045	0.365415	0.056550	0.509253	1.393629	0.015972	1.293100
179	(frozen produce)	(fresh fruits, fresh vegetables)	0.122580	0.317560	0.062170	0.507179	1.597112	0.023243	1.384762
386	(packaged cheese, yogurt)	(packaged vegetables fruits, fresh fruits)	0.088520	0.269870	0.044825	0.506383	1.876395	0.020936	1.479142
399	(packaged cheese, packaged vegetables fruits, ...	(yogurt)	0.068325	0.263675	0.034565	0.505891	1.918616	0.016549	1.490208
259	(fresh herbs)	(packaged vegetables fruits, fresh vegetables)	0.093005	0.234555	0.046980	0.505134	2.153585	0.025165	1.546773
54	(paper goods)	(fresh fruits)	0.063575	0.555995	0.032090	0.504758	0.907847	-0.003257	0.896542
315	(eggs, fresh vegetables)	(packaged vegetables fruits, fresh fruits)	0.084310	0.269870	0.042555	0.504744	1.870324	0.019802	1.474249
326	(fresh herbs, fresh vegetables)	(packaged vegetables fruits, fresh fruits)	0.078655	0.269870	0.039660	0.504227	1.868408	0.018433	1.472711
28	(eggs)	(packaged vegetables fruits)	0.136490	0.365415	0.068650	0.502967	1.376427	0.018775	1.276747
352	(packaged cheese, fresh vegetables)	(packaged vegetables fruits, fresh fruits)	0.135850	0.269870	0.068325	0.502944	1.863654	0.031663	1.468910
204	(pasta sauce)	(fresh fruits, fresh vegetables)	0.062660	0.317560	0.031430	0.501596	1.579531	0.011532	1.369250
344	(milk, fresh vegetables)	(packaged vegetables fruits, fresh fruits)	0.124715	0.269870	0.062535	0.501423	1.858018	0.028878	1.464428
296	(bread, fresh vegetables)	(packaged vegetables fruits, fresh fruits)	0.091590	0.269870	0.045910	0.501256	1.857397	0.021193	1.463936

# Generate the association rules - by lift

# Compute all association rules for frequent_itemsets
rulesLift_confidence = rulesConfidence[(rulesConfidence['lift'] > 1)].sort_values('lift', ascending=False)

# Show datafrmae
rulesLift_confidence.head()

	antecedents	consequents	antecedent support	consequent support	support	confidence	lift	leverage	conviction
325	(fresh fruits, fresh herbs)	(packaged vegetables fruits, fresh vegetables)	0.070135	0.234555	0.039660	0.565481	2.410867	0.023209	1.761591
324	(packaged vegetables fruits, fresh herbs)	(fresh fruits, fresh vegetables)	0.052535	0.317560	0.039660	0.754925	2.377268	0.022977	2.784620
404	(packaged cheese, yogurt, fresh vegetables)	(packaged vegetables fruits, fresh fruits)	0.057195	0.269870	0.034565	0.604336	2.239360	0.019130	1.845329
398	(milk, yogurt, fresh vegetables)	(packaged vegetables fruits, fresh fruits)	0.056510	0.269870	0.032845	0.581225	2.153721	0.017595	1.743488
259	(fresh herbs)	(packaged vegetables fruits, fresh vegetables)	0.093005	0.234555	0.046980	0.505134	2.153585	0.025165	1.546773

# Generate the association rules - by lift

# Compute all association rules for frequent_itemsets
rulesLift_confidence_min = rulesConfidence[(rulesConfidence['lift'] < 1)].sort_values('lift', ascending=False)

# Show datafrmae
rulesLift_confidence_min

	antecedents	consequents	antecedent support	consequent support	support	confidence	lift	leverage	conviction
54	(paper goods)	(fresh fruits)	0.063575	0.555995	0.03209	0.504758	0.907847	-0.003257	0.896542

Complementary Products

# Compute association rules for frequent_itemsets
rulesConfidence_two = association_rules(frequent_itemsets_two, metric="confidence", min_threshold=0.50)

# High Confidence and high Lift - complementary products
complementary_p = rulesConfidence_two[(rulesConfidence_two['lift'] > 1.3)].sort_values('lift', ascending=False)

complementary_p

	antecedents	consequents	antecedent support	consequent support	support	confidence	lift	leverage	conviction
65	(fresh herbs)	(fresh vegetables)	0.093005	0.444360	0.078655	0.845707	1.903203	0.037327	3.601205
10	(canned jarred vegetables)	(fresh vegetables)	0.071890	0.444360	0.055055	0.765823	1.723429	0.023110	2.372733
13	(canned meals beans)	(fresh vegetables)	0.069705	0.444360	0.050435	0.723549	1.628295	0.019461	2.009906
81	(spices seasonings)	(fresh vegetables)	0.052165	0.444360	0.036660	0.702770	1.581533	0.013480	1.869394
66	(fresh herbs)	(packaged vegetables fruits)	0.093005	0.365415	0.052535	0.564862	1.545810	0.018550	1.458354
24	(dry pasta)	(fresh vegetables)	0.070055	0.444360	0.047235	0.674256	1.517364	0.016105	1.705756
32	(fresh dips tapenades)	(packaged vegetables fruits)	0.098205	0.365415	0.053785	0.547681	1.498791	0.017899	1.402959
85	(frozen produce)	(packaged vegetables fruits)	0.122580	0.365415	0.066985	0.546459	1.495449	0.022192	1.399180
79	(soup broth bouillon)	(fresh vegetables)	0.083365	0.444360	0.055380	0.664308	1.494976	0.018336	1.655206
14	(canned meals beans)	(packaged vegetables fruits)	0.069705	0.365415	0.037670	0.540420	1.478922	0.012199	1.380794
78	(pasta sauce)	(fresh vegetables)	0.062660	0.444360	0.041005	0.654405	1.472690	0.013161	1.607777
83	(tortillas flat bread)	(fresh vegetables)	0.056455	0.444360	0.036525	0.646975	1.455971	0.011439	1.573942
77	(fresh vegetables)	(packaged vegetables fruits)	0.444360	0.365415	0.234555	0.527849	1.444519	0.072179	1.344030
76	(packaged vegetables fruits)	(fresh vegetables)	0.365415	0.444360	0.234555	0.641887	1.444519	0.072179	1.551576
11	(canned jarred vegetables)	(packaged vegetables fruits)	0.071890	0.365415	0.037835	0.526290	1.440253	0.011565	1.339607
68	(frozen produce)	(fresh vegetables)	0.122580	0.444360	0.077750	0.634280	1.427400	0.023280	1.519303
73	(oils vinegars)	(fresh vegetables)	0.067350	0.444360	0.042610	0.632665	1.423767	0.012682	1.512625
87	(pasta sauce)	(packaged vegetables fruits)	0.062660	0.365415	0.032595	0.520188	1.423555	0.009698	1.322571
25	(dry pasta)	(packaged vegetables fruits)	0.070055	0.365415	0.036440	0.520163	1.423485	0.010841	1.322500
86	(lunch meat)	(packaged vegetables fruits)	0.103890	0.365415	0.053225	0.512321	1.402024	0.015262	1.301234
27	(eggs)	(fresh vegetables)	0.136490	0.444360	0.084310	0.617701	1.390091	0.023659	1.453417
28	(eggs)	(packaged vegetables fruits)	0.136490	0.365415	0.068650	0.502967	1.376427	0.018775	1.276747
19	(condiments)	(fresh vegetables)	0.059465	0.444360	0.036290	0.610275	1.373380	0.009866	1.425723
33	(fresh herbs)	(fresh fruits)	0.093005	0.555995	0.070135	0.754099	1.356306	0.018425	1.805627
74	(other creams cheeses)	(fresh vegetables)	0.086485	0.444360	0.052105	0.602474	1.355825	0.013675	1.397747
7	(butter)	(fresh vegetables)	0.074330	0.444360	0.044580	0.599758	1.349712	0.011551	1.388260
0	(baby food formula)	(fresh fruits)	0.045355	0.555995	0.033810	0.745453	1.340754	0.008593	1.744292
53	(packaged vegetables fruits)	(fresh fruits)	0.365415	0.555995	0.269870	0.738530	1.328304	0.066701	1.698112
31	(fresh dips tapenades)	(fresh vegetables)	0.098205	0.444360	0.057955	0.590143	1.328074	0.014317	1.355693
75	(packaged cheese)	(fresh vegetables)	0.230995	0.444360	0.135850	0.588108	1.323494	0.033205	1.348994
69	(hot dogs bacon sausage)	(fresh vegetables)	0.084190	0.444360	0.049460	0.587481	1.322083	0.012049	1.346943
39	(frozen produce)	(fresh fruits)	0.122580	0.555995	0.089235	0.727974	1.309317	0.021081	1.632213
70	(lunch meat)	(fresh vegetables)	0.103890	0.444360	0.060095	0.578448	1.301756	0.013930	1.318083

Substitute Products

# Generate the association rules - by lift < 1

# Compute all association rules for frequent_itemsets
rulesLift_substitute = association_rules(frequent_itemsets, metric="lift", min_threshold=0.0)

# Sort values
rulesLift_substitute.sort_values(by='lift', ascending=True, inplace=True)

# Filter values above 1 and show the dataframe
rulesLift_substitute[(rulesLift_substitute['lift']<1) | (rulesLift_substitute['confidence'] > 0.5) ]

	antecedents	consequents	antecedent support	consequent support	support	confidence	lift	leverage	conviction
203	(fresh fruits)	(soft drinks)	0.555995	0.087310	0.039585	0.071197	0.815447	-0.008959	0.982652
202	(soft drinks)	(fresh fruits)	0.087310	0.555995	0.039585	0.453384	0.815447	-0.008959	0.812280
196	(paper goods)	(fresh fruits)	0.063575	0.555995	0.032090	0.504758	0.907847	-0.003257	0.896542
197	(fresh fruits)	(paper goods)	0.555995	0.063575	0.032090	0.057716	0.907847	-0.003257	0.993782
266	(water seltzer sparkling water)	(fresh vegetables)	0.193005	0.444360	0.083355	0.431880	0.971915	-0.002409	0.978033
267	(fresh vegetables)	(water seltzer sparkling water)	0.444360	0.193005	0.083355	0.187584	0.971915	-0.002409	0.993328
316	(milk)	(water seltzer sparkling water)	0.243325	0.193005	0.046610	0.191555	0.992485	-0.000353	0.998206
317	(water seltzer sparkling water)	(milk)	0.193005	0.243325	0.046610	0.241496	0.992485	-0.000353	0.997589
89	(coffee)	(fresh fruits)	0.055650	0.555995	0.031855	0.572417	1.029536	0.000914	1.038406
41	(candy chocolate)	(fresh fruits)	0.069305	0.555995	0.039820	0.574562	1.033394	0.001287	1.043641
216	(water seltzer sparkling water)	(fresh fruits)	0.193005	0.555995	0.111045	0.575348	1.034807	0.003735	1.045573
94	(cookies cakes)	(fresh fruits)	0.059725	0.555995	0.034610	0.579489	1.042256	0.001403	1.055871
175	(ice cream ice)	(fresh fruits)	0.110510	0.555995	0.064485	0.583522	1.049509	0.003042	1.066094
213	(tea)	(fresh fruits)	0.057010	0.555995	0.033720	0.591475	1.063814	0.002023	1.086850
164	(frozen meals)	(fresh fruits)	0.074330	0.555995	0.044090	0.593166	1.066854	0.002763	1.091365
2	(baking ingredients)	(fresh fruits)	0.076635	0.555995	0.047305	0.617277	1.110220	0.004696	1.160120
91	(condiments)	(fresh fruits)	0.059465	0.555995	0.036830	0.619356	1.113960	0.003768	1.166457
178	(juice nectars)	(fresh fruits)	0.089395	0.555995	0.055600	0.621959	1.118641	0.005897	1.174488
109	(cream)	(fresh fruits)	0.091605	0.555995	0.057010	0.622346	1.119337	0.006078	1.175692
70	(chips pretzels)	(fresh fruits)	0.169435	0.555995	0.106300	0.627379	1.128390	0.012095	1.191573
186	(oils vinegars)	(fresh fruits)	0.067350	0.555995	0.042885	0.636748	1.145241	0.005439	1.222307
160	(frozen appetizers sides)	(fresh fruits)	0.051875	0.555995	0.033035	0.636819	1.145369	0.004193	1.222546
208	(spices seasonings)	(fresh fruits)	0.052165	0.555995	0.033220	0.636825	1.145380	0.004217	1.222566
240	(milk)	(fresh vegetables)	0.243325	0.444360	0.124715	0.512545	1.153445	0.016591	1.139879
192	(packaged produce)	(fresh fruits)	0.062270	0.555995	0.039945	0.641481	1.153753	0.005323	1.238441
54	(cereal)	(fresh fruits)	0.092560	0.555995	0.059620	0.644123	1.158505	0.008157	1.247635
201	(refrigerated)	(fresh fruits)	0.134040	0.555995	0.086430	0.644808	1.159736	0.011904	1.250041
204	(soup broth bouillon)	(fresh fruits)	0.083365	0.555995	0.053880	0.646314	1.162446	0.007529	1.255366
172	(hot dogs bacon sausage)	(fresh fruits)	0.084190	0.555995	0.054425	0.646454	1.162698	0.007616	1.255864
177	(instant foods)	(fresh fruits)	0.051995	0.555995	0.033840	0.650832	1.170571	0.004931	1.271608
242	(nuts seeds dried fruit)	(fresh vegetables)	0.080225	0.444360	0.041775	0.520723	1.171849	0.006126	1.159329
262	(spreads)	(fresh vegetables)	0.078185	0.444360	0.040795	0.521775	1.174217	0.006053	1.161881
188	(other creams cheeses)	(fresh fruits)	0.086485	0.555995	0.056630	0.654796	1.177701	0.008545	1.286209
97	(crackers)	(fresh fruits)	0.114970	0.555995	0.075480	0.656519	1.180800	0.011557	1.292663
34	(butter)	(fresh fruits)	0.074330	0.555995	0.048920	0.658146	1.183727	0.007593	1.298815
226	(frozen breakfast)	(fresh vegetables)	0.061165	0.444360	0.032285	0.527835	1.187853	0.005106	1.176791
30	(breakfast bakery)	(fresh fruits)	0.067765	0.555995	0.045680	0.674094	1.212411	0.008003	1.362373
190	(packaged cheese)	(fresh fruits)	0.230995	0.555995	0.155900	0.674906	1.213871	0.027468	1.365776
182	(milk)	(fresh fruits)	0.243325	0.555995	0.164310	0.675270	1.214525	0.029023	1.367304
1062	(water seltzer sparkling water, yogurt)	(fresh vegetables)	0.056185	0.444360	0.030395	0.540981	1.217438	0.005429	1.210494
43	(canned jarred vegetables)	(fresh fruits)	0.071890	0.555995	0.048880	0.679928	1.222902	0.008910	1.387202
184	(nuts seeds dried fruit)	(fresh fruits)	0.080225	0.555995	0.054750	0.682456	1.227449	0.010145	1.398245
168	(fruit vegetable snacks)	(fresh fruits)	0.046085	0.555995	0.031460	0.682652	1.227802	0.005837	1.399109
199	(pasta sauce)	(fresh fruits)	0.062660	0.555995	0.042840	0.683690	1.229669	0.008001	1.403701
211	(spreads)	(fresh fruits)	0.078185	0.555995	0.053560	0.685042	1.232101	0.010090	1.409727
12	(bread)	(fresh fruits)	0.163865	0.555995	0.112410	0.685992	1.233809	0.021302	1.413990
268	(yogurt)	(fresh vegetables)	0.263675	0.444360	0.144660	0.548630	1.234652	0.027493	1.231008
118	(dry pasta)	(fresh fruits)	0.070055	0.555995	0.048095	0.686532	1.234781	0.009145	1.416429
139	(energy granola bars)	(fresh fruits)	0.086545	0.555995	0.059450	0.686926	1.235489	0.011331	1.418210
163	(frozen breakfast)	(fresh fruits)	0.061165	0.555995	0.042035	0.687239	1.236053	0.008028	1.419632
215	(tortillas flat bread)	(fresh fruits)	0.056455	0.555995	0.039205	0.694447	1.249016	0.007816	1.453119
180	(lunch meat)	(fresh fruits)	0.103890	0.555995	0.072290	0.695832	1.251508	0.014528	1.459737
206	(soy lactosefree)	(fresh fruits)	0.168355	0.555995	0.117480	0.697811	1.255067	0.023875	1.469297
124	(eggs)	(fresh fruits)	0.136490	0.555995	0.095325	0.698403	1.256131	0.019437	1.472179
14	(bread)	(fresh vegetables)	0.163865	0.444360	0.091590	0.558936	1.257844	0.018775	1.259771
258	(soy lactosefree)	(fresh vegetables)	0.168355	0.444360	0.094120	0.559057	1.258117	0.019310	1.260117
147	(fresh dips tapenades)	(fresh fruits)	0.098205	0.555995	0.069040	0.703019	1.264434	0.014439	1.495063
170	(hot cereal pancake mixes)	(fresh fruits)	0.045025	0.555995	0.031740	0.704942	1.267892	0.006706	1.504804
648	(fresh fruits, energy granola bars)	(fresh vegetables)	0.059450	0.444360	0.033845	0.569302	1.281173	0.007428	1.290092
792	(water seltzer sparkling water, fresh fruits)	(fresh vegetables)	0.111045	0.444360	0.063235	0.569454	1.281515	0.013891	1.290547
219	(yogurt)	(fresh fruits)	0.263675	0.555995	0.188225	0.713852	1.283919	0.041623	1.551664
159	(fresh vegetables)	(fresh fruits)	0.444360	0.555995	0.317560	0.714646	1.285346	0.070498	1.555978
158	(fresh fruits)	(fresh vegetables)	0.555995	0.444360	0.317560	0.571156	1.285346	0.070498	1.295670
4	(baking ingredients)	(fresh vegetables)	0.076635	0.444360	0.043790	0.571410	1.285917	0.009736	1.296437
48	(canned meals beans)	(fresh fruits)	0.069705	0.555995	0.049890	0.715731	1.287297	0.011134	1.561916
906	(water seltzer sparkling water, packaged cheese)	(fresh fruits)	0.048255	0.555995	0.034565	0.716299	1.288319	0.007735	1.565045
504	(packaged cheese, chips pretzels)	(fresh fruits)	0.056405	0.555995	0.040565	0.719174	1.293490	0.009204	1.581067
534	(chips pretzels, yogurt)	(fresh vegetables)	0.056980	0.444360	0.032885	0.577132	1.298795	0.007565	1.313981
870	(milk, water seltzer sparkling water)	(fresh fruits)	0.046610	0.555995	0.033700	0.723021	1.300409	0.007785	1.603027
238	(lunch meat)	(fresh vegetables)	0.103890	0.444360	0.060095	0.578448	1.301756	0.013930	1.318083
166	(frozen produce)	(fresh fruits)	0.122580	0.555995	0.089235	0.727974	1.309317	0.021081	1.632213
480	(cereal, fresh fruits)	(fresh vegetables)	0.059620	0.444360	0.034865	0.584787	1.316021	0.008372	1.338205
232	(hot dogs bacon sausage)	(fresh vegetables)	0.084190	0.444360	0.049460	0.587481	1.322083	0.012049	1.346943
559	(packaged cheese, crackers)	(fresh fruits)	0.043875	0.555995	0.032260	0.735271	1.322441	0.007866	1.677204
248	(packaged cheese)	(fresh vegetables)	0.230995	0.444360	0.135850	0.588108	1.323494	0.033205	1.348994
498	(milk, chips pretzels)	(fresh fruits)	0.048915	0.555995	0.036000	0.735971	1.323700	0.008804	1.681650
148	(fresh dips tapenades)	(fresh vegetables)	0.098205	0.444360	0.057955	0.590143	1.328074	0.014317	1.355693
194	(packaged vegetables fruits)	(fresh fruits)	0.365415	0.555995	0.269870	0.738530	1.328304	0.066701	1.698112
1002	(milk, yogurt)	(fresh vegetables)	0.095705	0.444360	0.056510	0.590460	1.328788	0.013983	1.356743
775	(soup broth bouillon, fresh vegetables)	(fresh fruits)	0.055380	0.555995	0.040940	0.739256	1.329609	0.010149	1.702839
402	(milk, bread)	(fresh vegetables)	0.059705	0.444360	0.035350	0.592078	1.332428	0.008819	1.362122
835	(lunch meat, packaged cheese)	(fresh fruits)	0.045205	0.555995	0.033515	0.741400	1.333466	0.008381	1.716959
367	(baking ingredients, fresh vegetables)	(fresh fruits)	0.043790	0.555995	0.032470	0.741493	1.333633	0.008123	1.717578
739	(oils vinegars, fresh vegetables)	(fresh fruits)	0.042610	0.555995	0.031600	0.741610	1.333843	0.007909	1.718352
714	(juice nectars, fresh fruits)	(fresh vegetables)	0.055600	0.444360	0.033055	0.594514	1.337912	0.008349	1.370308
452	(canned jarred vegetables, fresh vegetables)	(fresh fruits)	0.055055	0.555995	0.040955	0.743892	1.337948	0.010345	1.733666
522	(packaged cheese, chips pretzels)	(fresh vegetables)	0.056405	0.444360	0.033535	0.594539	1.337968	0.008471	1.370392
710	(ice cream ice, fresh vegetables)	(fresh fruits)	0.051995	0.555995	0.038700	0.744302	1.338685	0.009791	1.736445
768	(fresh fruits, refrigerated)	(fresh vegetables)	0.086430	0.444360	0.051445	0.595222	1.339503	0.013039	1.372702
0	(baby food formula)	(fresh fruits)	0.045355	0.555995	0.033810	0.745453	1.340754	0.008593	1.744292
961	(water seltzer sparkling water, yogurt)	(fresh fruits)	0.056185	0.555995	0.041895	0.745662	1.341130	0.010656	1.745726
582	(fresh fruits, cream)	(fresh vegetables)	0.057010	0.444360	0.033990	0.596211	1.341730	0.008657	1.376066
384	(bread, packaged cheese)	(fresh fruits)	0.059690	0.555995	0.044665	0.748283	1.345844	0.011478	1.763904
745	(other creams cheeses, fresh vegetables)	(fresh fruits)	0.052105	0.555995	0.039015	0.748777	1.346732	0.010045	1.767371
492	(chips pretzels, fresh fruits)	(fresh vegetables)	0.106300	0.444360	0.063685	0.599106	1.348245	0.016450	1.386003
36	(butter)	(fresh vegetables)	0.074330	0.444360	0.044580	0.599758	1.349712	0.011551	1.388260
708	(fresh fruits, ice cream ice)	(fresh vegetables)	0.064485	0.444360	0.038700	0.600140	1.350571	0.010045	1.389585
703	(hot dogs bacon sausage, fresh vegetables)	(fresh fruits)	0.049460	0.555995	0.037215	0.752426	1.353297	0.009715	1.793425
246	(other creams cheeses)	(fresh vegetables)	0.086485	0.444360	0.052105	0.602474	1.355825	0.013675	1.397747
157	(fresh herbs)	(fresh fruits)	0.093005	0.555995	0.070135	0.754099	1.356306	0.018425	1.805627
378	(milk, bread)	(fresh fruits)	0.059705	0.555995	0.045210	0.757223	1.361924	0.012014	1.828860
829	(packaged vegetables fruits, ice cream ice)	(fresh fruits)	0.043735	0.555995	0.033125	0.757403	1.362247	0.008809	1.830213
584	(cream, fresh vegetables)	(fresh fruits)	0.044830	0.555995	0.033990	0.758198	1.363677	0.009065	1.836231
726	(milk, fresh fruits)	(fresh vegetables)	0.164310	0.444360	0.099590	0.606110	1.364008	0.026577	1.410649
607	(eggs, packaged cheese)	(fresh fruits)	0.045435	0.555995	0.034460	0.758446	1.364124	0.009198	1.838120
793	(water seltzer sparkling water, fresh vegetables)	(fresh fruits)	0.083355	0.555995	0.063235	0.758623	1.364442	0.016890	1.839465
552	(fresh fruits, crackers)	(fresh vegetables)	0.075480	0.444360	0.045875	0.607777	1.367758	0.012335	1.416643
445	(butter, fresh vegetables)	(fresh fruits)	0.044580	0.555995	0.033965	0.761889	1.370316	0.009179	1.864696
864	(milk, soy lactosefree)	(fresh fruits)	0.041220	0.555995	0.031440	0.762737	1.371841	0.008522	1.871358
600	(milk, eggs)	(fresh fruits)	0.047795	0.555995	0.036475	0.763155	1.372594	0.009901	1.874666
92	(condiments)	(fresh vegetables)	0.059465	0.444360	0.036290	0.610275	1.373380	0.009866	1.425723
949	(yogurt, refrigerated)	(fresh fruits)	0.047175	0.555995	0.036030	0.763752	1.373667	0.009801	1.879402
589	(dry pasta, fresh vegetables)	(fresh fruits)	0.047235	0.555995	0.036115	0.764581	1.375159	0.009853	1.886023
924	(packaged vegetables fruits, soup broth bouillon)	(fresh fruits)	0.041045	0.555995	0.031405	0.765136	1.376156	0.008584	1.890476
132	(eggs)	(packaged vegetables fruits)	0.136490	0.365415	0.068650	0.502967	1.376427	0.018775	1.276747
852	(milk, packaged cheese)	(fresh fruits)	0.078170	0.555995	0.059885	0.766087	1.377866	0.016423	1.898161
1056	(soy lactosefree, yogurt)	(fresh vegetables)	0.058195	0.444360	0.035635	0.612338	1.378022	0.009775	1.433310
764	(pasta sauce, fresh vegetables)	(fresh fruits)	0.041005	0.555995	0.031430	0.766492	1.378595	0.008631	1.901454
936	(water seltzer sparkling water, packaged veget...	(fresh fruits)	0.073715	0.555995	0.056550	0.767144	1.379767	0.015565	1.906777
787	(fresh fruits, spreads)	(fresh vegetables)	0.053560	0.444360	0.032885	0.613984	1.381727	0.009085	1.439423
751	(packaged cheese, fresh vegetables)	(fresh fruits)	0.135850	0.555995	0.104570	0.769746	1.384448	0.029038	1.928327
517	(chips pretzels, yogurt)	(fresh fruits)	0.056980	0.555995	0.044025	0.772640	1.389652	0.012344	1.952868
715	(juice nectars, fresh vegetables)	(fresh fruits)	0.042775	0.555995	0.033055	0.772764	1.389877	0.009272	1.953942
126	(eggs)	(fresh vegetables)	0.136490	0.444360	0.084310	0.617701	1.390091	0.023659	1.453417
493	(chips pretzels, fresh vegetables)	(fresh fruits)	0.082245	0.555995	0.063685	0.774333	1.392697	0.017957	1.967521
937	(water seltzer sparkling water, fresh fruits)	(packaged vegetables fruits)	0.111045	0.365415	0.056550	0.509253	1.393629	0.015972	1.293100
572	(crackers, yogurt)	(fresh fruits)	0.043040	0.555995	0.033385	0.775674	1.395109	0.009455	1.979283
302	(lunch meat)	(packaged vegetables fruits)	0.103890	0.365415	0.053225	0.512321	1.402024	0.015262	1.301234
420	(bread, yogurt)	(fresh vegetables)	0.061840	0.444360	0.038560	0.623545	1.403242	0.011081	1.475978
822	(hot dogs bacon sausage, packaged vegetables f...	(fresh fruits)	0.040315	0.555995	0.031455	0.780231	1.403305	0.009040	2.020323
888	(packaged vegetables fruits, other creams chee...	(fresh fruits)	0.040265	0.555995	0.031435	0.780703	1.404154	0.009048	2.024673
769	(fresh vegetables, refrigerated)	(fresh fruits)	0.065825	0.555995	0.051445	0.781542	1.405664	0.014847	2.032450
830	(fresh fruits, ice cream ice)	(packaged vegetables fruits)	0.064485	0.365415	0.033125	0.513685	1.405759	0.009561	1.304886
877	(milk, yogurt)	(fresh fruits)	0.095705	0.555995	0.074860	0.782195	1.406839	0.021648	2.038546
510	(packaged vegetables fruits, chips pretzels)	(fresh fruits)	0.073545	0.555995	0.057595	0.783126	1.408513	0.016704	2.047295
595	(eggs, fresh vegetables)	(fresh fruits)	0.084310	0.555995	0.066145	0.784545	1.411065	0.019269	2.060780
732	(nuts seeds dried fruit, fresh fruits)	(fresh vegetables)	0.054750	0.444360	0.034350	0.627397	1.411912	0.010021	1.491240
686	(fresh herbs, fresh vegetables)	(fresh fruits)	0.078655	0.555995	0.061815	0.785900	1.413503	0.018083	2.073825
900	(soy lactosefree, packaged cheese)	(fresh fruits)	0.046265	0.555995	0.036390	0.786556	1.414681	0.010667	2.080192
463	(canned meals beans, fresh vegetables)	(fresh fruits)	0.050435	0.555995	0.039670	0.786557	1.414684	0.011628	2.080204
798	(fresh fruits, yogurt)	(fresh vegetables)	0.188225	0.444360	0.118420	0.629141	1.415835	0.034780	1.498250
990	(milk, packaged cheese)	(fresh vegetables)	0.078170	0.444360	0.049305	0.630741	1.419436	0.014569	1.504742
373	(bread, fresh vegetables)	(fresh fruits)	0.091590	0.555995	0.072365	0.790097	1.421051	0.021441	2.115288
804	(frozen produce, packaged cheese)	(fresh fruits)	0.038850	0.555995	0.030715	0.790605	1.421964	0.009115	2.120417
913	(packaged cheese, yogurt)	(fresh fruits)	0.088520	0.555995	0.070020	0.791008	1.422688	0.020803	2.124504
408	(bread, packaged cheese)	(fresh vegetables)	0.059690	0.444360	0.037740	0.632267	1.422870	0.011216	1.510986
123	(dry pasta)	(packaged vegetables fruits)	0.070055	0.365415	0.036440	0.520163	1.423485	0.010841	1.322500
341	(pasta sauce)	(packaged vegetables fruits)	0.062660	0.365415	0.032595	0.520188	1.423555	0.009698	1.322571
894	(packaged cheese, packaged vegetables fruits)	(fresh fruits)	0.114610	0.555995	0.090715	0.791510	1.423593	0.026992	2.129626
397	(bread, yogurt)	(fresh fruits)	0.061840	0.555995	0.048950	0.791559	1.423680	0.014567	2.130122
244	(oils vinegars)	(fresh vegetables)	0.067350	0.444360	0.042610	0.632665	1.423767	0.012682	1.512625
955	(soy lactosefree, yogurt)	(fresh fruits)	0.058195	0.555995	0.046075	0.791735	1.423996	0.013719	2.131920
230	(frozen produce)	(fresh vegetables)	0.122580	0.444360	0.077750	0.634280	1.427400	0.023280	1.519303
919	(packaged vegetables fruits, refrigerated)	(fresh fruits)	0.058705	0.555995	0.046595	0.793714	1.427557	0.013955	2.152379
757	(packaged vegetables fruits, fresh vegetables)	(fresh fruits)	0.234555	0.555995	0.186580	0.795464	1.430703	0.056169	2.170789
721	(lunch meat, fresh vegetables)	(fresh fruits)	0.060095	0.555995	0.047870	0.796572	1.432697	0.014457	2.182616
426	(milk, bread)	(packaged vegetables fruits)	0.059705	0.365415	0.031295	0.524160	1.434425	0.009478	1.333611
727	(milk, fresh vegetables)	(fresh fruits)	0.124715	0.555995	0.099590	0.798541	1.436237	0.030249	2.203944
486	(packaged vegetables fruits, cereal)	(fresh fruits)	0.039750	0.555995	0.031780	0.799497	1.437957	0.009679	2.214454
1044	(water seltzer sparkling water, packaged veget...	(fresh vegetables)	0.073715	0.444360	0.047105	0.639015	1.438057	0.014349	1.539233
697	(frozen produce, fresh vegetables)	(fresh fruits)	0.077750	0.555995	0.062170	0.799614	1.438168	0.018941	2.215750
554	(crackers, fresh vegetables)	(fresh fruits)	0.057335	0.555995	0.045875	0.800122	1.439081	0.013997	2.221381
47	(canned jarred vegetables)	(packaged vegetables fruits)	0.071890	0.365415	0.037835	0.526290	1.440253	0.011565	1.339607
619	(eggs, yogurt)	(fresh fruits)	0.049905	0.555995	0.040000	0.801523	1.441601	0.012253	2.237059
612	(eggs, packaged vegetables fruits)	(fresh fruits)	0.068650	0.555995	0.055045	0.801821	1.442137	0.016876	2.240422
624	(milk, eggs)	(fresh vegetables)	0.047795	0.444360	0.030660	0.641490	1.443626	0.009422	1.549858
251	(fresh vegetables)	(packaged vegetables fruits)	0.444360	0.365415	0.234555	0.527849	1.444519	0.072179	1.344030
250	(packaged vegetables fruits)	(fresh vegetables)	0.365415	0.444360	0.234555	0.641887	1.444519	0.072179	1.551576
781	(soy lactosefree, fresh vegetables)	(fresh fruits)	0.094120	0.555995	0.075620	0.803442	1.445053	0.023290	2.258905
667	(packaged vegetables fruits, fresh dips tapena...	(fresh fruits)	0.053785	0.555995	0.043245	0.804035	1.446118	0.013341	2.265731
662	(fresh dips tapenades, fresh vegetables)	(fresh fruits)	0.057955	0.555995	0.046625	0.804503	1.446962	0.014402	2.271166
481	(cereal, fresh vegetables)	(fresh fruits)	0.043325	0.555995	0.034865	0.804732	1.447372	0.010777	2.273820
565	(packaged vegetables fruits, crackers)	(fresh fruits)	0.052650	0.555995	0.042385	0.805033	1.447915	0.013112	2.277337
780	(soy lactosefree, fresh fruits)	(fresh vegetables)	0.117480	0.444360	0.075620	0.643684	1.448564	0.023417	1.559402
372	(bread, fresh fruits)	(fresh vegetables)	0.112410	0.444360	0.072365	0.643759	1.448734	0.022414	1.559733
788	(spreads, fresh vegetables)	(fresh fruits)	0.040795	0.555995	0.032885	0.806104	1.449840	0.010203	2.289909
840	(lunch meat, packaged vegetables fruits)	(fresh fruits)	0.053225	0.555995	0.043000	0.807891	1.453054	0.013407	2.311214
1020	(packaged cheese, yogurt)	(fresh vegetables)	0.088520	0.444360	0.057195	0.646125	1.454058	0.017860	1.570160
674	(fresh dips tapenades, yogurt)	(fresh fruits)	0.037500	0.555995	0.030350	0.809333	1.455649	0.009500	2.328698
264	(tortillas flat bread)	(fresh vegetables)	0.056455	0.444360	0.036525	0.646975	1.455971	0.011439	1.573942
859	(milk, fresh fruits)	(packaged vegetables fruits)	0.164310	0.365415	0.087450	0.532226	1.456497	0.027409	1.356605
390	(bread, packaged vegetables fruits)	(fresh fruits)	0.077055	0.555995	0.062430	0.810201	1.457208	0.019588	2.339337
488	(cereal, fresh fruits)	(packaged vegetables fruits)	0.059620	0.365415	0.031780	0.533043	1.458732	0.009994	1.358978
468	(packaged vegetables fruits, canned meals beans)	(fresh fruits)	0.037670	0.555995	0.030560	0.811256	1.459106	0.009616	2.352415
847	(lunch meat, yogurt)	(fresh fruits)	0.039605	0.555995	0.032140	0.811514	1.459570	0.010120	2.355635
810	(frozen produce, packaged vegetables fruits)	(fresh fruits)	0.066985	0.555995	0.054415	0.812346	1.461067	0.017172	2.366084
858	(milk, packaged vegetables fruits)	(fresh fruits)	0.107425	0.555995	0.087450	0.814056	1.464143	0.027722	2.387847
817	(frozen produce, yogurt)	(fresh fruits)	0.045295	0.555995	0.036900	0.814659	1.465228	0.011716	2.395617
1081	(milk, yogurt)	(packaged vegetables fruits)	0.095705	0.365415	0.051295	0.535970	1.466743	0.016323	1.367551
1280	(milk, fresh fruits, yogurt)	(fresh vegetables)	0.074860	0.444360	0.048835	0.652351	1.468069	0.015570	1.598279
528	(packaged vegetables fruits, chips pretzels)	(fresh vegetables)	0.073545	0.444360	0.048105	0.654089	1.471981	0.015425	1.606311
799	(fresh vegetables, yogurt)	(fresh fruits)	0.144660	0.555995	0.118420	0.818609	1.472332	0.037990	2.447781
252	(pasta sauce)	(fresh vegetables)	0.062660	0.444360	0.041005	0.654405	1.472690	0.013161	1.607777
1026	(packaged vegetables fruits, refrigerated)	(fresh vegetables)	0.058705	0.444360	0.038470	0.655310	1.474729	0.012384	1.612001
920	(fresh fruits, refrigerated)	(packaged vegetables fruits)	0.086430	0.365415	0.046595	0.539107	1.475327	0.015012	1.376859
1351	(water seltzer sparkling water, packaged veget...	(fresh fruits)	0.047105	0.555995	0.038645	0.820401	1.475555	0.012455	2.472205
1014	(soy lactosefree, packaged cheese)	(fresh vegetables)	0.046265	0.444360	0.030345	0.655895	1.476045	0.009787	1.614741
733	(nuts seeds dried fruit, fresh vegetables)	(fresh fruits)	0.041775	0.555995	0.034350	0.822262	1.478902	0.011123	2.498089
53	(canned meals beans)	(packaged vegetables fruits)	0.069705	0.365415	0.037670	0.540420	1.478922	0.012199	1.380794
930	(soy lactosefree, packaged vegetables fruits)	(fresh fruits)	0.081385	0.555995	0.066960	0.822756	1.479790	0.021710	2.505050
882	(nuts seeds dried fruit, packaged vegetables f...	(fresh fruits)	0.038315	0.555995	0.031575	0.824090	1.482189	0.010272	2.524043
512	(chips pretzels, fresh fruits)	(packaged vegetables fruits)	0.106300	0.365415	0.057595	0.541816	1.482740	0.018751	1.384999
943	(packaged vegetables fruits, yogurt)	(fresh fruits)	0.127910	0.555995	0.105790	0.827066	1.487542	0.034673	2.567481
541	(packaged cheese, chips pretzels)	(packaged vegetables fruits)	0.056405	0.365415	0.030665	0.543657	1.487781	0.010054	1.390589
691	(packaged vegetables fruits, fresh herbs)	(fresh fruits)	0.052535	0.555995	0.043490	0.827829	1.488915	0.014281	2.578862
720	(lunch meat, fresh fruits)	(fresh vegetables)	0.072290	0.444360	0.047870	0.662194	1.490220	0.015747	1.644849
1099	(bread, packaged cheese, fresh vegetables)	(fresh fruits)	0.037740	0.555995	0.031275	0.828696	1.490474	0.010292	2.591918
256	(soup broth bouillon)	(fresh vegetables)	0.083365	0.444360	0.055380	0.664308	1.494976	0.018336	1.655206
276	(frozen produce)	(packaged vegetables fruits)	0.122580	0.365415	0.066985	0.546459	1.495449	0.022192	1.399180
650	(energy granola bars, fresh vegetables)	(fresh fruits)	0.040640	0.555995	0.033845	0.832800	1.497856	0.011249	2.655535
153	(fresh dips tapenades)	(packaged vegetables fruits)	0.098205	0.365415	0.053785	0.547681	1.498791	0.017899	1.402959
1295	(packaged cheese, packaged vegetables fruits, ...	(fresh fruits)	0.081970	0.555995	0.068325	0.833537	1.499180	0.022750	2.667284
655	(packaged vegetables fruits, energy granola bars)	(fresh fruits)	0.039500	0.555995	0.032945	0.834051	1.500105	0.010983	2.675545
576	(packaged vegetables fruits, crackers)	(fresh vegetables)	0.052650	0.444360	0.035225	0.669041	1.505628	0.011829	1.678878
1155	(packaged vegetables fruits, chips pretzels, f...	(fresh fruits)	0.048105	0.555995	0.040325	0.838270	1.507694	0.013579	2.745355
642	(eggs, yogurt)	(fresh vegetables)	0.049905	0.444360	0.033470	0.670674	1.509304	0.011294	1.687205
1407	(milk, packaged cheese, yogurt)	(fresh fruits)	0.038465	0.555995	0.032280	0.839204	1.509374	0.010894	2.761302
750	(packaged cheese, fresh fruits)	(fresh vegetables)	0.155900	0.444360	0.104570	0.670750	1.509475	0.035294	1.687595
1378	(soy lactosefree, fresh fruits, yogurt)	(fresh vegetables)	0.046075	0.444360	0.030910	0.670863	1.509728	0.010436	1.688171
1183	(eggs, packaged vegetables fruits, fresh veget...	(fresh fruits)	0.050675	0.555995	0.042555	0.839763	1.510379	0.014380	2.770930
548	(chips pretzels, yogurt)	(packaged vegetables fruits)	0.056980	0.365415	0.031465	0.552211	1.511189	0.010644	1.417153
1253	(milk, packaged cheese, fresh vegetables)	(fresh fruits)	0.049305	0.555995	0.041475	0.841193	1.512950	0.014062	2.795871
656	(fresh fruits, energy granola bars)	(packaged vegetables fruits)	0.059450	0.365415	0.032945	0.554163	1.516531	0.011221	1.423357
120	(dry pasta)	(fresh vegetables)	0.070055	0.444360	0.047235	0.674256	1.517364	0.016105	1.705756
1324	(refrigerated, packaged vegetables fruits, fre...	(fresh fruits)	0.038470	0.555995	0.032460	0.843774	1.517593	0.011071	2.842075
1212	(packaged vegetables fruits, fresh herbs, fres...	(fresh fruits)	0.046980	0.555995	0.039660	0.844189	1.518339	0.013539	2.849639
890	(other creams cheeses, fresh fruits)	(packaged vegetables fruits)	0.056630	0.365415	0.031435	0.555094	1.519080	0.010742	1.426337
660	(fresh fruits, fresh dips tapenades)	(fresh vegetables)	0.069040	0.444360	0.046625	0.675333	1.519788	0.015946	1.711416
391	(bread, fresh fruits)	(packaged vegetables fruits)	0.112410	0.365415	0.062430	0.555378	1.519855	0.021354	1.427245
1198	(packaged vegetables fruits, fresh dips tapena...	(fresh fruits)	0.038095	0.555995	0.032265	0.846962	1.523326	0.011084	2.901264
1225	(frozen produce, packaged vegetables fruits, f...	(fresh fruits)	0.048895	0.555995	0.041445	0.847633	1.524533	0.014260	2.914044
432	(bread, packaged cheese)	(packaged vegetables fruits)	0.059690	0.365415	0.033280	0.557547	1.525792	0.011468	1.434244
1239	(lunch meat, packaged vegetables fruits, fresh...	(fresh fruits)	0.037600	0.555995	0.031940	0.849468	1.527834	0.011035	2.949574
1093	(soy lactosefree, yogurt)	(packaged vegetables fruits)	0.058195	0.365415	0.032535	0.559069	1.529955	0.011270	1.439192
996	(milk, packaged vegetables fruits)	(fresh vegetables)	0.107425	0.444360	0.073075	0.680242	1.530835	0.025340	1.737689
1113	(bread, packaged vegetables fruits, fresh vege...	(fresh fruits)	0.053835	0.555995	0.045910	0.852791	1.533810	0.015978	3.016153
1392	(milk, packaged cheese, packaged vegetables fr...	(fresh fruits)	0.043830	0.555995	0.037380	0.852841	1.533900	0.013011	3.017169
1126	(bread, fresh fruits, yogurt)	(fresh vegetables)	0.048950	0.444360	0.033370	0.681716	1.534153	0.011619	1.745737
1068	(milk, packaged cheese)	(packaged vegetables fruits)	0.078170	0.365415	0.043830	0.560701	1.534423	0.015266	1.444540
566	(fresh fruits, crackers)	(packaged vegetables fruits)	0.075480	0.365415	0.042385	0.561539	1.536717	0.014803	1.447302
1350	(water seltzer sparkling water, packaged veget...	(fresh vegetables)	0.056550	0.444360	0.038645	0.683378	1.537892	0.013516	1.754898
439	(bread, yogurt)	(packaged vegetables fruits)	0.061840	0.365415	0.034755	0.562015	1.538018	0.012158	1.448873
944	(fresh fruits, yogurt)	(packaged vegetables fruits)	0.188225	0.365415	0.105790	0.562040	1.538087	0.037010	1.448957
702	(hot dogs bacon sausage, fresh fruits)	(fresh vegetables)	0.054425	0.444360	0.037215	0.683785	1.538809	0.013031	1.757159
1267	(milk, packaged vegetables fruits, fresh veget...	(fresh fruits)	0.073075	0.555995	0.062535	0.855765	1.539159	0.021906	3.078336
631	(eggs, packaged cheese)	(fresh vegetables)	0.045435	0.444360	0.031160	0.685815	1.543377	0.010971	1.768512
1309	(packaged cheese, fresh vegetables, yogurt)	(fresh fruits)	0.057195	0.555995	0.049105	0.858554	1.544176	0.017305	3.139044
366	(baking ingredients, fresh fruits)	(fresh vegetables)	0.047305	0.444360	0.032470	0.686397	1.544686	0.011450	1.771793
225	(fresh herbs)	(packaged vegetables fruits)	0.093005	0.365415	0.052535	0.564862	1.545810	0.018550	1.458354
1337	(soy lactosefree, packaged vegetables fruits, ...	(fresh fruits)	0.057695	0.555995	0.049600	0.859693	1.546225	0.017522	3.164530
1045	(water seltzer sparkling water, fresh vegetables)	(packaged vegetables fruits)	0.083355	0.365415	0.047105	0.565113	1.546497	0.016646	1.459195
1050	(packaged vegetables fruits, yogurt)	(fresh vegetables)	0.127910	0.444360	0.087995	0.687945	1.548170	0.031157	1.780582
1170	(packaged vegetables fruits, crackers, fresh v...	(fresh fruits)	0.035225	0.555995	0.030350	0.861604	1.549661	0.010765	3.208221
744	(other creams cheeses, fresh fruits)	(fresh vegetables)	0.056630	0.444360	0.039015	0.688946	1.550423	0.013851	1.786312
1435	(packaged cheese, packaged vegetables fruits, ...	(fresh fruits)	0.051915	0.555995	0.044825	0.863431	1.552947	0.015961	3.251131
1281	(milk, fresh vegetables, yogurt)	(fresh fruits)	0.056510	0.555995	0.048835	0.864183	1.554301	0.017416	3.269150
756	(packaged vegetables fruits, fresh fruits)	(fresh vegetables)	0.269870	0.444360	0.186580	0.691370	1.555878	0.066661	1.800343
1127	(bread, fresh vegetables, yogurt)	(fresh fruits)	0.038560	0.555995	0.033370	0.865405	1.556497	0.011931	3.298812
978	(frozen produce, yogurt)	(fresh vegetables)	0.045295	0.444360	0.031330	0.691688	1.556593	0.011203	1.802199
1365	(packaged vegetables fruits, fresh vegetables,...	(fresh fruits)	0.087995	0.555995	0.076240	0.866413	1.558311	0.027315	3.323711
1252	(milk, packaged cheese, fresh fruits)	(fresh vegetables)	0.059885	0.444360	0.041475	0.692577	1.558595	0.014865	1.807415
931	(soy lactosefree, fresh fruits)	(packaged vegetables fruits)	0.117480	0.365415	0.066960	0.569969	1.559786	0.024031	1.475674
1379	(soy lactosefree, fresh vegetables, yogurt)	(fresh fruits)	0.035635	0.555995	0.030910	0.867406	1.560096	0.011097	3.348596
594	(eggs, fresh fruits)	(fresh vegetables)	0.095325	0.444360	0.066145	0.693889	1.561548	0.023786	1.815160
444	(butter, fresh fruits)	(fresh vegetables)	0.048920	0.444360	0.033965	0.694297	1.562465	0.012227	1.817580
1421	(milk, packaged vegetables fruits, yogurt)	(fresh fruits)	0.051295	0.555995	0.044575	0.868993	1.562951	0.016055	3.389172
1141	(bread, packaged vegetables fruits, yogurt)	(fresh fruits)	0.034755	0.555995	0.030265	0.870810	1.566219	0.010941	3.436836
1323	(packaged vegetables fruits, fresh fruits, ref...	(fresh vegetables)	0.046595	0.444360	0.032460	0.696641	1.567741	0.011755	1.831627
696	(frozen produce, fresh fruits)	(fresh vegetables)	0.089235	0.444360	0.062170	0.696700	1.567872	0.022518	1.831980
414	(bread, packaged vegetables fruits)	(fresh vegetables)	0.077055	0.444360	0.053835	0.698657	1.572277	0.019595	1.843878
1154	(packaged vegetables fruits, chips pretzels, f...	(fresh vegetables)	0.057595	0.444360	0.040325	0.700148	1.575631	0.014732	1.853045
1098	(bread, packaged cheese, fresh fruits)	(fresh vegetables)	0.044665	0.444360	0.031275	0.700213	1.575778	0.011428	1.853447
1308	(packaged cheese, fresh fruits, yogurt)	(fresh vegetables)	0.070020	0.444360	0.049105	0.701300	1.578224	0.017991	1.860192
883	(nuts seeds dried fruit, fresh fruits)	(packaged vegetables fruits)	0.054750	0.365415	0.031575	0.576712	1.578239	0.011569	1.499181
766	(pasta sauce)	(fresh fruits, fresh vegetables)	0.062660	0.317560	0.031430	0.501596	1.579531	0.011532	1.369250
613	(eggs, fresh fruits)	(packaged vegetables fruits)	0.095325	0.365415	0.055045	0.577446	1.580246	0.020212	1.501783
260	(spices seasonings)	(fresh vegetables)	0.052165	0.444360	0.036660	0.702770	1.581533	0.013480	1.869394
823	(hot dogs bacon sausage, fresh fruits)	(packaged vegetables fruits)	0.054425	0.365415	0.031455	0.577951	1.581630	0.011567	1.503582
1034	(soup broth bouillon, fresh vegetables)	(packaged vegetables fruits)	0.055380	0.365415	0.032055	0.578819	1.584005	0.011818	1.506680
458	(canned jarred vegetables, fresh vegetables)	(packaged vegetables fruits)	0.055055	0.365415	0.031925	0.579875	1.586893	0.011807	1.510466
984	(lunch meat, packaged vegetables fruits)	(fresh vegetables)	0.053225	0.444360	0.037600	0.706435	1.589781	0.013949	1.892732
895	(packaged cheese, fresh fruits)	(packaged vegetables fruits)	0.155900	0.365415	0.090715	0.581879	1.592380	0.033747	1.517708
678	(packaged vegetables fruits, fresh dips tapena...	(fresh vegetables)	0.053785	0.444360	0.038095	0.708283	1.593940	0.014195	1.904723
926	(soup broth bouillon, fresh fruits)	(packaged vegetables fruits)	0.053880	0.365415	0.031405	0.582869	1.595089	0.011716	1.521310
1038	(soy lactosefree, packaged vegetables fruits)	(fresh vegetables)	0.081385	0.444360	0.057695	0.708914	1.595361	0.021531	1.908854
699	(frozen produce)	(fresh fruits, fresh vegetables)	0.122580	0.317560	0.062170	0.507179	1.597112	0.023243	1.384762
1027	(fresh vegetables, refrigerated)	(packaged vegetables fruits)	0.065825	0.365415	0.038470	0.584428	1.599355	0.014417	1.527017
1462	(milk, packaged vegetables fruits, yogurt)	(fresh vegetables)	0.051295	0.444360	0.036455	0.710693	1.599363	0.013662	1.920590
530	(chips pretzels, fresh vegetables)	(packaged vegetables fruits)	0.082245	0.365415	0.048105	0.584899	1.600642	0.018051	1.528748
997	(milk, fresh vegetables)	(packaged vegetables fruits)	0.124715	0.365415	0.073075	0.585936	1.603481	0.027502	1.532577
1087	(packaged cheese, yogurt)	(packaged vegetables fruits)	0.088520	0.365415	0.051915	0.586478	1.604963	0.019568	1.534584
1284	(milk, yogurt)	(fresh fruits, fresh vegetables)	0.095705	0.317560	0.048835	0.510266	1.606833	0.018443	1.393491
758	(fresh fruits, fresh vegetables)	(packaged vegetables fruits)	0.317560	0.365415	0.186580	0.587543	1.607877	0.070539	1.538546
759	(packaged vegetables fruits)	(fresh fruits, fresh vegetables)	0.365415	0.317560	0.186580	0.510598	1.607877	0.070539	1.394435
415	(bread, fresh vegetables)	(packaged vegetables fruits)	0.091590	0.365415	0.053835	0.587783	1.608534	0.020367	1.539442
1523	(packaged cheese, packaged vegetables fruits, ...	(fresh fruits)	0.038635	0.555995	0.034565	0.894655	1.609106	0.013084	4.214775
1266	(milk, packaged vegetables fruits, fresh fruits)	(fresh vegetables)	0.087450	0.444360	0.062535	0.715094	1.609268	0.023676	1.950260
1008	(packaged cheese, packaged vegetables fruits)	(fresh vegetables)	0.114610	0.444360	0.081970	0.715208	1.609524	0.031042	1.951039
1168	(packaged vegetables fruits, fresh fruits, cra...	(fresh vegetables)	0.042385	0.444360	0.030350	0.716055	1.611430	0.011516	1.956859
1492	(milk, packaged vegetables fruits, yogurt, fre...	(fresh fruits)	0.036455	0.555995	0.032845	0.900974	1.620471	0.012576	4.483713
1364	(packaged vegetables fruits, fresh fruits, yog...	(fresh vegetables)	0.105790	0.444360	0.076240	0.720673	1.621822	0.029231	1.989210
591	(dry pasta)	(fresh fruits, fresh vegetables)	0.070055	0.317560	0.036115	0.515524	1.623389	0.013868	1.408613
841	(lunch meat, fresh fruits)	(packaged vegetables fruits)	0.072290	0.365415	0.043000	0.594826	1.627811	0.016584	1.566205
50	(canned meals beans)	(fresh vegetables)	0.069705	0.444360	0.050435	0.723549	1.628295	0.019461	2.009906
1422	(milk, fresh fruits, yogurt)	(packaged vegetables fruits)	0.074860	0.365415	0.044575	0.595445	1.629503	0.017220	1.568599
968	(fresh herbs, fresh vegetables)	(packaged vegetables fruits)	0.078655	0.365415	0.046980	0.597292	1.634558	0.018238	1.575794
972	(frozen produce, packaged vegetables fruits)	(fresh vegetables)	0.066985	0.444360	0.048895	0.729940	1.642676	0.019130	2.057465
637	(eggs, fresh vegetables)	(packaged vegetables fruits)	0.084310	0.365415	0.050675	0.601056	1.644858	0.019867	1.590660
1102	(bread, packaged cheese)	(fresh fruits, fresh vegetables)	0.059690	0.317560	0.031275	0.523957	1.649947	0.012320	1.433568
1354	(water seltzer sparkling water, packaged veget...	(fresh fruits, fresh vegetables)	0.073715	0.317560	0.038645	0.524249	1.650865	0.015236	1.434447
762	(fresh fruits, pasta sauce)	(fresh vegetables)	0.042840	0.444360	0.031430	0.733660	1.651049	0.012394	2.086207
1009	(packaged cheese, fresh vegetables)	(packaged vegetables fruits)	0.135850	0.365415	0.081970	0.603386	1.651235	0.032328	1.600007
1448	(milk, packaged cheese, packaged vegetables fr...	(fresh vegetables)	0.043830	0.444360	0.032215	0.734999	1.654062	0.012739	2.096746
1112	(bread, packaged vegetables fruits, fresh fruits)	(fresh vegetables)	0.062430	0.444360	0.045910	0.735384	1.654928	0.018169	2.099795
476	(canned meals beans, fresh vegetables)	(packaged vegetables fruits)	0.050435	0.365415	0.030555	0.605829	1.657921	0.012125	1.609924
1491	(milk, packaged vegetables fruits, fresh fruit...	(fresh vegetables)	0.044575	0.444360	0.032845	0.736848	1.658223	0.013038	2.111479
738	(oils vinegars, fresh fruits)	(fresh vegetables)	0.042885	0.444360	0.031600	0.736854	1.658237	0.012544	2.111530
636	(eggs, packaged vegetables fruits)	(fresh vegetables)	0.068650	0.444360	0.050675	0.738165	1.661186	0.020170	2.122097
1052	(fresh vegetables, yogurt)	(packaged vegetables fruits)	0.144660	0.365415	0.087995	0.608288	1.664651	0.035134	1.620031
1336	(soy lactosefree, packaged vegetables fruits, ...	(fresh vegetables)	0.066960	0.444360	0.049600	0.740741	1.666983	0.019846	2.143183
811	(frozen produce, fresh fruits)	(packaged vegetables fruits)	0.089235	0.365415	0.054415	0.609794	1.668772	0.021807	1.626284
1256	(milk, packaged cheese)	(fresh fruits, fresh vegetables)	0.078170	0.317560	0.041475	0.530574	1.670785	0.016651	1.453777
1238	(lunch meat, packaged vegetables fruits, fresh...	(fresh vegetables)	0.043000	0.444360	0.031940	0.742791	1.671597	0.012833	2.160264
1352	(water seltzer sparkling water, fresh fruits, ...	(packaged vegetables fruits)	0.063235	0.365415	0.038645	0.611133	1.672436	0.015538	1.631882
1382	(soy lactosefree, yogurt)	(fresh fruits, fresh vegetables)	0.058195	0.317560	0.030910	0.531145	1.672582	0.012430	1.455547
1476	(packaged cheese, packaged vegetables fruits, ...	(fresh vegetables)	0.051915	0.444360	0.038635	0.744197	1.674762	0.015566	2.172142
469	(canned meals beans, fresh fruits)	(packaged vegetables fruits)	0.049890	0.365415	0.030560	0.612548	1.676307	0.012329	1.637840
1039	(soy lactosefree, fresh vegetables)	(packaged vegetables fruits)	0.094120	0.365415	0.057695	0.612994	1.677528	0.023302	1.639729
1196	(packaged vegetables fruits, fresh fruits, fre...	(fresh vegetables)	0.043245	0.444360	0.032265	0.746098	1.679039	0.013049	2.188402
578	(crackers, fresh vegetables)	(packaged vegetables fruits)	0.057335	0.365415	0.035225	0.614372	1.681298	0.014274	1.645587
588	(dry pasta, fresh fruits)	(fresh vegetables)	0.048095	0.444360	0.036115	0.750910	1.689868	0.014744	2.230677
1142	(bread, fresh fruits, yogurt)	(packaged vegetables fruits)	0.048950	0.365415	0.030265	0.618284	1.692005	0.012378	1.662453
1294	(packaged cheese, packaged vegetables fruits, ...	(fresh vegetables)	0.090715	0.444360	0.068325	0.753183	1.694984	0.028015	2.251223
692	(fresh fruits, fresh herbs)	(packaged vegetables fruits)	0.070135	0.365415	0.043490	0.620090	1.696947	0.017862	1.670355
1130	(bread, yogurt)	(fresh fruits, fresh vegetables)	0.061840	0.317560	0.033370	0.539618	1.699264	0.013732	1.482335
1393	(milk, packaged cheese, fresh fruits)	(packaged vegetables fruits)	0.059885	0.365415	0.037380	0.624196	1.708185	0.015497	1.688608
774	(soup broth bouillon, fresh fruits)	(fresh vegetables)	0.053880	0.444360	0.040940	0.759837	1.709957	0.016998	2.313592
985	(lunch meat, fresh vegetables)	(packaged vegetables fruits)	0.060095	0.365415	0.037600	0.625676	1.712234	0.015640	1.695283
1224	(frozen produce, packaged vegetables fruits, f...	(fresh vegetables)	0.054415	0.444360	0.041445	0.761647	1.714031	0.017265	2.331160
668	(fresh fruits, fresh dips tapenades)	(packaged vegetables fruits)	0.069040	0.365415	0.043245	0.626376	1.714150	0.018017	1.698459
1268	(milk, fresh fruits, fresh vegetables)	(packaged vegetables fruits)	0.099590	0.365415	0.062535	0.627924	1.718387	0.026143	1.705527
973	(frozen produce, fresh vegetables)	(packaged vegetables fruits)	0.077750	0.365415	0.048895	0.628875	1.720987	0.020484	1.709894
44	(canned jarred vegetables)	(fresh vegetables)	0.071890	0.444360	0.055055	0.765823	1.723429	0.023110	2.372733
1158	(packaged vegetables fruits, chips pretzels)	(fresh fruits, fresh vegetables)	0.073545	0.317560	0.040325	0.548304	1.726615	0.016970	1.510838
1325	(refrigerated, fresh fruits, fresh vegetables)	(packaged vegetables fruits)	0.051445	0.365415	0.032460	0.630965	1.726708	0.013661	1.719580
1157	(chips pretzels, fresh fruits, fresh vegetables)	(packaged vegetables fruits)	0.063685	0.365415	0.040325	0.633195	1.732810	0.017054	1.730032
1522	(packaged cheese, packaged vegetables fruits, ...	(fresh vegetables)	0.044825	0.444360	0.034565	0.771110	1.735327	0.014647	2.427540
1114	(bread, fresh fruits, fresh vegetables)	(packaged vegetables fruits)	0.072365	0.365415	0.045910	0.634423	1.736170	0.019467	1.735844
1182	(eggs, packaged vegetables fruits, fresh fruits)	(fresh vegetables)	0.055045	0.444360	0.042555	0.773095	1.739794	0.018095	2.448775
1328	(packaged vegetables fruits, refrigerated)	(fresh fruits, fresh vegetables)	0.058705	0.317560	0.032460	0.552934	1.741196	0.013818	1.526487
1312	(packaged cheese, yogurt)	(fresh fruits, fresh vegetables)	0.088520	0.317560	0.049105	0.554733	1.746862	0.020995	1.532655
1436	(packaged cheese, fresh fruits, yogurt)	(packaged vegetables fruits)	0.070020	0.365415	0.044825	0.640174	1.751910	0.019239	1.763590
1213	(fresh fruits, fresh herbs, fresh vegetables)	(packaged vegetables fruits)	0.061815	0.365415	0.039660	0.641592	1.755790	0.017072	1.770565
1032	(packaged vegetables fruits, soup broth bouillon)	(fresh vegetables)	0.041045	0.444360	0.032055	0.780972	1.757521	0.013816	2.536846
1184	(eggs, fresh fruits, fresh vegetables)	(packaged vegetables fruits)	0.066145	0.365415	0.042555	0.643359	1.760626	0.018385	1.779340
1366	(fresh fruits, fresh vegetables, yogurt)	(packaged vegetables fruits)	0.118420	0.365415	0.076240	0.643810	1.761860	0.032968	1.781592
1464	(milk, fresh vegetables, yogurt)	(packaged vegetables fruits)	0.056510	0.365415	0.036455	0.645107	1.765409	0.015805	1.788103
1449	(milk, packaged cheese, fresh vegetables)	(packaged vegetables fruits)	0.049305	0.365415	0.032215	0.653382	1.788055	0.014198	1.830791
1296	(packaged cheese, fresh fruits, fresh vegetables)	(packaged vegetables fruits)	0.104570	0.365415	0.068325	0.653390	1.788077	0.030114	1.830833
462	(canned meals beans, fresh fruits)	(fresh vegetables)	0.049890	0.444360	0.039670	0.795149	1.789426	0.017501	2.712415
465	(canned meals beans)	(fresh fruits, fresh vegetables)	0.069705	0.317560	0.039670	0.569113	1.792142	0.017534	1.583802
454	(canned jarred vegetables)	(fresh fruits, fresh vegetables)	0.071890	0.317560	0.040955	0.569690	1.793960	0.018126	1.585926
1338	(soy lactosefree, fresh fruits, fresh vegetables)	(packaged vegetables fruits)	0.075620	0.365415	0.049600	0.655911	1.794976	0.021967	1.844247
680	(fresh dips tapenades, fresh vegetables)	(packaged vegetables fruits)	0.057955	0.365415	0.038095	0.657320	1.798832	0.016917	1.851832
1171	(fresh fruits, crackers, fresh vegetables)	(packaged vegetables fruits)	0.045875	0.365415	0.030350	0.661580	1.810490	0.013587	1.875142
1173	(packaged vegetables fruits, crackers)	(fresh fruits, fresh vegetables)	0.052650	0.317560	0.030350	0.576448	1.815242	0.013630	1.611232
1226	(frozen produce, fresh fruits, fresh vegetables)	(packaged vegetables fruits)	0.062170	0.365415	0.041445	0.666640	1.824336	0.018727	1.903602
474	(packaged vegetables fruits, canned meals beans)	(fresh vegetables)	0.037670	0.444360	0.030555	0.811123	1.825373	0.013816	2.941807
1240	(lunch meat, fresh fruits, fresh vegetables)	(packaged vegetables fruits)	0.047870	0.365415	0.031940	0.667224	1.825934	0.014448	1.906942
1270	(milk, packaged vegetables fruits)	(fresh fruits, fresh vegetables)	0.107425	0.317560	0.062535	0.582127	1.833125	0.028421	1.633128
1493	(milk, yogurt, fresh fruits, fresh vegetables)	(packaged vegetables fruits)	0.048835	0.365415	0.032845	0.672571	1.840567	0.015000	1.938084
1478	(packaged cheese, fresh vegetables, yogurt)	(packaged vegetables fruits)	0.057195	0.365415	0.038635	0.675496	1.848572	0.017735	1.955554
1118	(bread, fresh vegetables)	(packaged vegetables fruits, fresh fruits)	0.091590	0.269870	0.045910	0.501256	1.857397	0.021193	1.463936
1272	(milk, fresh vegetables)	(packaged vegetables fruits, fresh fruits)	0.124715	0.269870	0.062535	0.501423	1.858018	0.028878	1.464428
1300	(packaged cheese, fresh vegetables)	(packaged vegetables fruits, fresh fruits)	0.135850	0.269870	0.068325	0.502944	1.863654	0.031663	1.468910
1219	(fresh herbs, fresh vegetables)	(packaged vegetables fruits, fresh fruits)	0.078655	0.269870	0.039660	0.504227	1.868408	0.018433	1.472711
1188	(eggs, fresh vegetables)	(packaged vegetables fruits, fresh fruits)	0.084310	0.269870	0.042555	0.504744	1.870324	0.019802	1.474249
1116	(bread, packaged vegetables fruits)	(fresh fruits, fresh vegetables)	0.077055	0.317560	0.045910	0.595808	1.876207	0.021440	1.688406
1440	(packaged cheese, yogurt)	(packaged vegetables fruits, fresh fruits)	0.088520	0.269870	0.044825	0.506383	1.876395	0.020936	1.479142
1368	(packaged vegetables fruits, yogurt)	(fresh fruits, fresh vegetables)	0.127910	0.317560	0.076240	0.596044	1.876950	0.035621	1.689392
1298	(packaged cheese, packaged vegetables fruits)	(fresh fruits, fresh vegetables)	0.114610	0.317560	0.068325	0.596152	1.877290	0.031929	1.689844
450	(fresh fruits, canned jarred vegetables)	(fresh vegetables)	0.048880	0.444360	0.040955	0.837868	1.885562	0.019235	3.427089
1201	(packaged vegetables fruits, fresh dips tapena...	(fresh fruits, fresh vegetables)	0.053785	0.317560	0.032265	0.599888	1.889055	0.015185	1.705624
1242	(lunch meat, packaged vegetables fruits)	(fresh fruits, fresh vegetables)	0.053225	0.317560	0.031940	0.600094	1.889703	0.015038	1.706501
1199	(fresh fruits, fresh dips tapenades, fresh veg...	(packaged vegetables fruits)	0.046625	0.365415	0.032265	0.692011	1.893767	0.015228	2.060413
456	(packaged vegetables fruits, canned jarred veg...	(fresh vegetables)	0.037835	0.444360	0.031925	0.843795	1.898901	0.015113	3.557130
220	(fresh herbs)	(fresh vegetables)	0.093005	0.444360	0.078655	0.845707	1.903203	0.037327	3.601205
1521	(packaged cheese, packaged vegetables fruits, ...	(yogurt)	0.068325	0.263675	0.034565	0.505891	1.918616	0.016549	1.490208
1340	(soy lactosefree, packaged vegetables fruits)	(fresh fruits, fresh vegetables)	0.081385	0.317560	0.049600	0.609449	1.919161	0.023755	1.747377
1524	(yogurt, fresh fruits, packaged cheese, fresh ...	(packaged vegetables fruits)	0.049105	0.365415	0.034565	0.703900	1.926302	0.016621	2.143143
1420	(milk, packaged vegetables fruits, fresh fruits)	(yogurt)	0.087450	0.263675	0.044575	0.509720	1.933137	0.021517	1.501845
1228	(frozen produce, packaged vegetables fruits)	(fresh fruits, fresh vegetables)	0.066985	0.317560	0.041445	0.618721	1.948358	0.020173	1.789869
1186	(eggs, packaged vegetables fruits)	(fresh fruits, fresh vegetables)	0.068650	0.317560	0.042555	0.619883	1.952020	0.020755	1.795344
1342	(soy lactosefree, fresh vegetables)	(packaged vegetables fruits, fresh fruits)	0.094120	0.269870	0.049600	0.526987	1.952743	0.024200	1.543572
1370	(fresh vegetables, yogurt)	(packaged vegetables fruits, fresh fruits)	0.144660	0.269870	0.076240	0.527029	1.952899	0.037201	1.543710
1177	(crackers, fresh vegetables)	(packaged vegetables fruits, fresh fruits)	0.057335	0.269870	0.030350	0.529345	1.961482	0.014877	1.551306
1244	(lunch meat, fresh vegetables)	(packaged vegetables fruits, fresh fruits)	0.060095	0.269870	0.031940	0.531492	1.969436	0.015722	1.558415
1230	(frozen produce, fresh vegetables)	(packaged vegetables fruits, fresh fruits)	0.077750	0.269870	0.041445	0.533055	1.975228	0.020463	1.563631
684	(fresh fruits, fresh herbs)	(fresh vegetables)	0.070135	0.444360	0.061815	0.881372	1.983463	0.030650	4.683872
1490	(milk, packaged vegetables fruits, fresh fruit...	(yogurt)	0.062535	0.263675	0.032845	0.525226	1.991944	0.016356	1.550895
966	(packaged vegetables fruits, fresh herbs)	(fresh vegetables)	0.052535	0.444360	0.046980	0.894261	2.012470	0.023636	5.254824
1497	(milk, packaged vegetables fruits, yogurt)	(fresh fruits, fresh vegetables)	0.051295	0.317560	0.032845	0.640316	2.016362	0.016556	1.897331
1406	(milk, packaged cheese, fresh fruits)	(yogurt)	0.059885	0.263675	0.032280	0.539033	2.044309	0.016490	1.597349
1210	(packaged vegetables fruits, fresh fruits, fre...	(fresh vegetables)	0.043490	0.444360	0.039660	0.911934	2.052241	0.020335	6.309343
1205	(fresh dips tapenades, fresh vegetables)	(packaged vegetables fruits, fresh fruits)	0.057955	0.269870	0.032265	0.556725	2.062938	0.016625	1.647127
688	(fresh herbs)	(fresh fruits, fresh vegetables)	0.093005	0.317560	0.061815	0.664642	2.092964	0.032280	2.034958
1530	(packaged cheese, packaged vegetables fruits, ...	(fresh fruits, fresh vegetables)	0.051915	0.317560	0.034565	0.665800	2.096611	0.018079	2.042010
970	(fresh herbs)	(packaged vegetables fruits, fresh vegetables)	0.093005	0.234555	0.046980	0.505134	2.153585	0.025165	1.546773
1500	(milk, yogurt, fresh vegetables)	(packaged vegetables fruits, fresh fruits)	0.056510	0.269870	0.032845	0.581225	2.153721	0.017595	1.743488
1534	(packaged cheese, yogurt, fresh vegetables)	(packaged vegetables fruits, fresh fruits)	0.057195	0.269870	0.034565	0.604336	2.239360	0.019130	1.845329
1215	(packaged vegetables fruits, fresh herbs)	(fresh fruits, fresh vegetables)	0.052535	0.317560	0.039660	0.754925	2.377268	0.022977	2.784620
1217	(fresh fruits, fresh herbs)	(packaged vegetables fruits, fresh vegetables)	0.070135	0.234555	0.039660	0.565481	2.410867	0.023209	1.761591

Heat Map of Complementary Produtcs

# Create visualization for the lifts

# Create column with the number of the left hand side items
complementary_p['lhs items'] = complementary_p['antecedents'].apply(lambda x:len(x) )

# Create column with the number of the right hand side items
complementary_p['rhs items'] = complementary_p['consequents'].apply(lambda x:len(x) )

# Replace frozen sets with strings
complementary_p['antecedents_'] = complementary_p['antecedents'].apply(lambda a: ','.join(list(a)))
complementary_p['consequents_'] = complementary_p['consequents'].apply(lambda a: ','.join(list(a)))

# Transform the DataFrame of rules into a matrix using the lift metric
pivot = complementary_p.pivot(index = 'consequents_', columns = 'antecedents_', values= 'lift')

# Generate a heatmap with annotations on and the colorbar off
fig, ax = plt.subplots(figsize=(20, 2))
sns.heatmap(pivot, annot = True, cmap=("rocket_r"))
plt.yticks(rotation=0)
plt.xticks(rotation=90)
plt.show()

Complementary Products Plot

# Create two columns with the antecedent and consequent products as strings
complementary_p['lhs products'] = complementary_p['antecedents'].apply(lambda a: ','.join(list(a)))
complementary_p['rhs products'] = complementary_p['consequents'].apply(lambda a: ','.join(list(a)))

# Remove duplicated rules if reversed rules
complementary_p['sortedRow'] = [sorted([a,b]) for a,b in zip(complementary_p['lhs products'], complementary_p['rhs products'])]
complementary_p['sortedRow'] = complementary_p['sortedRow'].astype(str)
complementary_p.drop_duplicates(subset=['sortedRow'], inplace=True)

# Create a list with the unique products from the left hand side (antecedents) and right hand side (consequents)
nodes_graph = pd.Series(complementary_p['lhs products'])
nodes_graph = nodes_graph.append(pd.Series(complementary_p['rhs products']))
nodes_graph = nodes_graph.unique().tolist()

# function to create tuples containing the antecedent, consequent and lift for each rule (row) 
def directed_edges(row):
    edge_graph = (row['lhs products'], row['rhs products'], round(row['lift'], 2))
    return edge_graph 

# apply the function
complementary_p['edge'] = complementary_p.apply(lambda row: directed_edges(row), axis=1)

# save the new created column to a list
edges_graph = complementary_p['edge'].to_list()

The default settings of this graph do not provide a clear visualization of its elements. Therefore, for a better placement for the plot elements and an overall better visualization, it was choosen that the boxes (representing the products) can be manually dragged, allowing the user to create a better plot.

#  set directed Graph
G = nx.DiGraph()

# set nodes and directions
G.add_nodes_from(nodes_graph)
G.add_weighted_edges_from(edges_graph)

# set canvas
canvas = jupyter_canvas()
canvas.size((650, 650))
canvas.edgelayout('symmetric').edgelength(80)

# add and set the nodes to the canvas
canvas.nodes(G.nodes).add(shape='rect', size=(80, 12),  fixed=True)

# add and set the edges (the lines that conect the nodes) to the canvas
canvas.edges(G.edges).add(labels=lambda e: {0: {'text': G.edges[e]['weight']}}).directed(True)

# display graph
canvas